Hello All,

I have a formula that is almost working.
I am trying make sure that if two specific criteria are met that the revenue
column(f in this case) gets multiplied by K1 or K2 depending on the
evaluation.

I am hoping to simplify the following and be error free.

=IF(OR(C50="",D50=""),"",IF(D50="Services A",F50*$K$1,IF(AND(SEARCH("Company
A",C50),D50="Services B"),F50*$K$2,IF(D50="Services B",F50*$K$1,""))))

this is returning an Value Error

any suggestions on how to go about this.