Forum Discussion
C_Rose
Jan 17, 2019Copper Contributor
Excel "IF" formula in two different cells only one if not calculating correctly.
I have the same formula in 2 different cells, one returns the correct value of 30 and the other does not. I need help with the formula, please. File attached.
Jan 17, 2019
Hello,
do we really need to see a 3 MB workbook to illustrate your problem? It's downloading extremely slowly.
While it does that ... Your formula is not the same. One refers to J20 and the other one refers to L20.
Your file has still not finished downloading.