Need drop down selection to return different format and formulas

[amajor99]

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

[FDibbins]

Hi, welcome to the forum

1. Formulas cannot affect other cells, only the cell they reside in
2. Formulas cannot merge cells (almost never a good idea to use merged cells anyway, they cause problems with formulas)
3. if A1 = Fixed, maybe just have a formula in B3 that says =if(A1="Fixed","""$") AND C3 that says =if)A1="Fixed","","total")

[amajor99]

ok thank you! Do you have any suggestions of how to lay this our? IT is for customers to enter pricing.