From: TTB on 5 Feb 2010 19:50 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! From: rzink on 5 Feb 2010 20:24 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! From: "David Biddulph" groups [at] on 6 Feb 2010 06:09 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"))