If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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.laanemetsattarkon.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. |
Thread Tools | |
Display Modes | |
|
|