Calculate new price with conditions

  • Thread starter Thread starter matt4003
  • Start date Start date
M

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
 
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?
 
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))
 
Back
Top