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


On Nov 7, 12:41*am, ForeverH
wrote:
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)