Thread: Excel - Negative nested if then conditions
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
TTB TTB is offline
external usenet poster
  
Posts: 1
Default 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!
Reply With QuoteReply With Quote