View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Debbie Debbie is offline
external usenet poster
 
Posts: 90
Default 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!