Link to home
Start Free TrialLog in
Avatar of Bill Golden
Bill GoldenFlag for United States of America

asked on

Using a numeric value in a formula based on existence of a value in another cell in Excel

B1 contains a numeric value.
I want the value in B4 to be a percentage of B1 based upon the following:

If only A2 contains an "X", then B4 is to be 20.00% of B1
If only A3 contains an "X", then B4 is to be 15.00% of B1
If both A2 and A3 contain an "X", then B4 is to be 35.00% of B1
ASKER CERTIFIED SOLUTION
Avatar of Rgonzo1971
Rgonzo1971

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
How about
=IF(A2="X",IF(A3="X",B1*35/100,B1*20/100),IF(A3="X",B1*15/100,"?"))

Open in new window

Avatar of Bill Golden

ASKER

Worked Beautifully!