Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If a cell is specified by the user, use formula.
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If a cell is specified by the user, use formula.
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,FormulaFo rMass)) D2=IF(OR(A2="",B2=""),"",IF(A2="IBU",B2,FormulaFor IBU)) -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "AdamT" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible? | Excel Worksheet Functions | |||
assign formula to another cell | Excel Worksheet Functions | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel |