View Single Post
  #1   Report Post  
jerry
 
Posts: n/a
Default 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.