complicated if function

  • Thread starter Thread starter ForeverH
  • Start date Start date
F

ForeverH

i need to pose a question that has 4 possible responses. each response will
dictate a cell to have a quantity

A1: Fins? B2: response is either; BM, Reno, Stucco, Nail

Column B header is QTY
A2:BM B2: 2 (if response is BM) 0 (if response is anything else)
A3:Reno B3: 2 (if response is Reno) 0 (if response is anything else)
A4:Stucco B4: 2 (if response is Stucco) 0 (if response is anything else)

how do i create a formula for this?

Oh and to make matters worse there is a qty for the sheet. if the qty for
the sheet is 1 than the above is correct.
if the qty for the sheet is 2 or anything else than B2, B3, and B4 need to
be multiplied by that qty*2

ex: (sheet qty is 2 than B2 qty is 4, sheet qty is 3 than B2 is 6)
 
Presumably sheet qty is in a cell somewhere? Assume it is D1. Put this
formula in B2:

=IF(B$1=A2,2,0)*D$1

Then copy into B3:B4

What happens if you select Nail in B1?

Hope this helps.

Pete
 
Thank you! that worked.

- if the response is nail there will be no qtys to formulate (nail requires
nothing done)

Thanks again
 
You're welcome - thanks for feeding back.

Pete

Thank you!  that worked.  

- if the response is nail there will be no qtys to formulate (nail requires
nothing done)

Thanks again







- Show quoted text -
Click to expand...
 
Back
Top