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))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Determine if time is within a windoww 2
Cask beer being recognised by UNESCO as a UK intangable part of British life and its brewing and cultural history. i may not have said that very well 5
Help With Formula For Cell Addresses 2
if then formula 3
Reference text in a cell inside a formula to specify a sheet name 4
Subsequence of characters 5
How can I add down a list a specified number of cells? 9
how do i format a cell to use text and formulas 3

Back
Top