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.

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))),....

jerry wrote:

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

Dave u da man!

thanks a bunch, works like a charm now

"Dave Peterson" wrote:

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))),....

jerry wrote:

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