simplyfy and help on errors

[Guest]

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.

 

[Dave Peterson]

This portion of your formula:

IF(AND(SEARCH("Company A",C50), ...
will return an error if "company A" isn't in C50.

Maybe
IF(AND(isnumber(SEARCH("Company A",C50))),....

 

[Guest]

Dave u da man!

thanks a bunch, works like a charm now