Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
nested if based on nested if in seperate sheet. how? | Excel Worksheet Functions | |||
Any Nested Function & Condition For Calculating Date & Time | Excel Worksheet Functions | |||
Nested if | Excel Worksheet Functions | |||
Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions | |||
Q: Nested if | Excel Discussion (Misc queries) |