Thanks so much for your response, however, I had already done this to
reactivate the cell several times. It's still just sitting there. BTW...it
is already formatted as a text field.

Any further suggestions are welcome... :)

"PCLIVE" wrote:

Click on the cell, press F2 and then press Enter. See if that helps.


"Debbie" wrote in message
...
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!