If a cell is specified by the user, use formula.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have searched the forums and couldn't find the answer to my question, so
here goes.

I have a spreadsheet that calculates Bittering Units (beer brewing) by
specifying AA% of the hops (not variable), and the weight and it will
determine the Bittering Units.

Is there any way I can allow the user to either specify the IBU, or the
mass, and for Excel to automatically calculate the other one without deleting
the formula from the cell which has been specified?

i.e. in the mass cell: If IBU is specified, calculate mass, however if mass
is specified, calculate IBU

Cheers.
 
Hi

Use 2 columns for entries, and 2 additional column for calculated values.
For first entry column, apply data validation list to select between
mass/IBU, into second column, enter the value for selected parameter.
In calculated columns, use formulas like
C2=IF(OR(A2="",B2=""),"",IF(A2="mass",B2,FormulaForMass))
D2=IF(OR(A2="",B2=""),"",IF(A2="IBU",B2,FormulaForIBU))
 
Back
Top