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
Avatar of Rgonzo1971

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
How about

Open in new window

Avatar of Bill Golden


Worked Beautifully!