William, I went back and looked at your first response and I think I know
what I did. When I read the first line, it told me, in a literal sense that
"the cell ... must be formatted as text." Yes, I did see the part where you
said to change it to General, but I think my brain latched onto the literal
interpretation of your first sentence. Then I goofed up the process when
changing it to General, and that made my mind go right back to your first
sentence. I realize now that what you were actually telling me is that I
"must have formatted the cell as text in error" and it should be General.

Sorry I was a little thick in interpretting your first solution...that
really should have been the end of it!

Thanks again for all your help.

Debbie

"William Horton" wrote:

The cell that your formula is in must be formatted as text. Change the
format to General and then enter the formula again (or hit F2 and then
enter). Your formula should then calculate the appropriate answer.

Hope that helps.

"Debbie" wrote:

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!