Nested IFs Not Calculating
I'm using XL2000. I know...I'm way outdated. I have what seems to be a
simple nested IF statement, but when I leave the cell, it just sits there and
doesn't calculate the answer...it just shows the formula itself. Here is my
formula:
=IF(J21.1,"Cheap",IF(J2<0.8,"Expensive","Neutral" ))
Is that not simple? Obviously, J2 refers back to a cell. Now, the
referenced cell is also a formula, but it didn't fix the problem when I
copied/pasted the values for the referenced cell so it was working with an
actual number.
What am I doing wrong???
Thanks for assisting!
|