Prev: If statement to go through every worksheet
Next: Replacing a formula with the actual string or number
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"))


 | 
Pages: 1
Prev: If statement to go through every worksheet
Next: Replacing a formula with the actual string or number