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
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