Calculate new price with conditions

[matt4003]

Hi,

I need a little help, and I am sure it is easy and I'm just missing
it.

I have a starting price in B1 and I want to use percent adders to
calculate the new price if there is an "X" in a cell A2:A5. B2:B5 have
corresponding percent adders, like 10% in B2. So if A2 has an "X" then
I would (B1*B2)+B1 to get new price. If there is an "X" in A2 and A3,
then I would ((B1*B2)+(B1*B3)+B1). I am having a hard time getting the
formula to recognize which A2:A5 have an "X" to do the calculation for
B2:B5...any suggestions?

Thanks,
Matt

 

[Myrna Larson]

What do you want to do when column A does NOT have an X? You menation A2 and
A3 having X. Can you have A2 and A5 with an X, A3 and A4 without an X?

 

[Paul Lautman]

In your total price cell:

=B1*(1+IF(A2="X",B2,0)+IF(A3="X",B3,0)+IF(A4="X",B4,0)+IF(A5="X",B5,0))