Hi All!

I am trying to create a formula and need some help. In cell A1, it will be a choice of fixed or variable. I would like cell A2 through C3 to return:

if A1 is fixed, then A2:C3 should merge and the person filling this out can put in a fixed amount of $1000


if A1 is variable, then I would like for cell A2 to say Unit, B3 to say $, C3 to say total. Then, in cell A3 they can input # of units, cell B3 the amount per unit, and then cell C3 would calculate A3 multiplied by B3

Fixed
$20,000.00


Variable
Unit $ Total
20 $50.00 $1,000.00