Home |
Search |
Today's Posts |
#1
|
|||
|
|||
simplyfy and help on errors
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. |