Bill Golden

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

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

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

Worked Beautifully!

Open in new window