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. |
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. |
All times are GMT +1. The time now is 02:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com