nested IF's or AND's-PROBLEM SOLVED-THANKS EVERYONE

[underpar]

Hi There:
Could someone give me some help in writing a formula that has several IF statements? H10, K10 and L10 are cells.

Here is what I'm trying to do:
IF H10<105% then 0
If H10>=105% AND k10=no then L10 X .02
IF H10 >=105% AND k10=yes then L10 X .04

Does anyone have a solution? I'd appreciate it.
Many thanks,
Mike

 

[Greg Truby]

What happens if K10 = neither "yes" nor "no" or will K10 always equal "yes" or "no"?

The following assumes that K10 must be either "yes" or "no"...

=IF(H10<1.05,0,L10*IF(LOWER(K10)="no",0.02,0.04))

 

[Seti]

Re: nested IF's or AND's

Try this:

=IF(H10<1.05,0,L10*IF(K10="no",.02,.04))

Oh, and welcome to the forum.