| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel - Negative nested if then conditions
Help, my formulas does not seem to calculate negative numbers. If a= 91 then
result is 30 days. =if(a<-90,"-90days",if(a<-60,"-60days","30 days")) -- TTB Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel - Negative nested if then conditions
TTB,
You need to give the formula a complete cell reference A1, or A2, not just A. =if(a1<-90,"-90days",if(a1<-60,"-60days","30 days")) Also if you want -90 to return "-90days", and -60 to return "-60days", then you will need to replace "<" with "<=" like this: =if(a<=-90,"-90days",if(a<=-60,"-60days","30 days")) Hope this helps. Ryan "TTB" wrote: Help, my formulas does not seem to calculate negative numbers. If a= 91 then result is 30 days. =if(a<-90,"-90days",if(a<-60,"-60days","30 days")) -- TTB Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel - Negative nested if then conditions
That's correct.
91<-90 is false 91<-60 is false "30 days" is the correct answer from the formula. If a were -91 you would get "-90days" If a were -61 or -89 you would get "-60days" -- David Biddulph TTB wrote: Help, my formulas does not seem to calculate negative numbers. If a= 91 then result is 30 days. =if(a<-90,"-90days",if(a<-60,"-60days","30 days")) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nested IF Statement 3 Conditions, Need Help Fixing | Excel Discussion (Misc queries) | |||
| nested if based on nested if in seperate sheet. how? | Excel Worksheet Functions | |||
| Nested if statement with over 7 conditions - VBA? | Excel Discussion (Misc queries) | |||
| I want to have a nested IF with two conditions | Excel Discussion (Misc queries) | |||
| Nested IF functions and 3 conditions | Excel Worksheet Functions | |||
Hybrid Mode
