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)