calculation based on meeting two criteria
I have the following formula and it returns the wrong calculation
K1 =.03
K2 =.02
In this situation, its supposed to multiply F82*K2, instead it is
multiplying F82* K1
=IF(E82="service a",F82*$K$1,IF(AND(E82="Service B",MATCH(C82,'Sheet
2!$C$2:$C$15)),F82*$K$1,F82*$K$2))
any help is appreciated.
|