Nested IFs Not Calculating

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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(J2>1.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!
 
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.
 
Thank you so much for your quick response! I really appreciate it very much.

I had already formatted the column as text before creating the formula. I
did reformat to General as you suggested and then opened the cell with the
formula and hit Enter and it's still just sitting there.

Any other suggestions?
 
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... :)
 
The problem is that the cell is formatted as a text field. It needs to be
formatted as GENERAL. Please change the format to General and then re-enter
the formula in the cell.

Any cell formatted as TEXT will just show whatever you type in it. It will
not calculate any formulas. That is why you must change the cell format to
General.
 
Thank you, William. I had it formulated as General and thought I had
reactivated the cell after doing so and got the same results. This time I
was careful to do exacly as you asked and it worked. That was a big DUH in
my book. I just wasn't thinking apparently.

Have a good day and thanks so much for your help!
 
Perhaps that cell has been formatted as Text. Click on the cell and
Format | Cells | Number (tab) and select General | OK. Then double-
click in the cell as if to edit it and then click elsewhere (or press
Enter) to make the formatting change take effect.

Hope this helps.

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

Thanks!
 
This allows you to see all of your formula cells. Since you can't tell if a
cell contains a formula without clicking on them, it is difficult to find
those formula cells...especially if some of your formulas return blank
results.

Regards,
Paul
 
Cool! That's a new one for me. Thanks for the info, Paul. I appreciate
your helpfulness!

Debbie
 
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
 
Back
Top