Formula Problem

[Chet28]

this formula is not working and I can't seem to figuare out what I did wrong,

=IF(B28>0,'Support and Lease'!$D$24,IF(B28>150,'Support and Lease'!$D$25))

the first if statement returns the correct answer but the second if statement does not.

Any suggestions on how to fix this?

thanks- chet

 

[Blade Hunter]

Because if it is >150 then it is also >0 and it quits out after the first IF is satisfied.

Try this:

=IF(B28>150,'Support and Lease'!$D$25,IF(B28>0,'Support and Lease'!$D$24,""))

Run in order of satisfaction posibilities.

 

[Marcelo Branco]

Hi,

With your formula you never get the second IF because if B28 > 150 its also > 0 and returns D24

Maybe you can reverse the conditions

=IF(B28>150,'Support and Lease'!$D$25,IF(B28>0,'Support and Lease'!$D$24))

and what return do you want if B28 <= 0 ?

HTH

M.

 

[Chet28]

Hey Blade-

Thanks a ton- worked like a champ-

Chet