Thank you for responding. I did get the answer I was looking for, but I was
wondering what Ctrl+~ does...

Thanks!

"PCLIVE" wrote:

Try pressing Ctrl+~

"~" is the symbol above the Tab key.


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