Working with Variables and Formulas

Including Variables in Formulas

Just as you can use keywords in place of string and numeric constants, you can use variables in place of string and numeric values. For example, in place of the #BATCH in the previous example, you can use the variable #YEAST.

Deleting Variables

Be careful about deleting a variable. If you delete a variable that another variable or recipe item references, the Recipe Builder displays the text ?????? in the Calc Val column of the item that referenced the deleted variable. While the Recipe Builder displays this text, the recipe cannot be downloaded. To fix this situation, do one of the following actions:

• Edit the formula of the recipe item or variable that references the deleted variable.
• Create a variable with the same name as the variable you deleted.
• Override the recipe item or variable that references the deleted variable.

To avoid deleting variables that are referenced by another item in the spreadsheet, search the Formula column for the variable name before you delete it from the recipe.