Excel - Negative nested if then conditions

  • Thread starter Thread starter TTB
  • Start date Start date
T

TTB

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,

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