Entering Override Limits

When you add or insert a recipe item or variable, the Recipe Builder automatically sets the high and low override limits to Unrestricted. This allows anyone to enter any override value needed. If you want to restrict the possible value of the override value, change the override limits.

To enter an override limit into the Override Lo Lim column or the Override Hi Lim column, select a cell in either column and type the limit you want in the text editing box.    

The following table provides guidelines for entering values in each column. If you are entering values from the text editing box, follow the guidelines below.

Override Limits

To set an override limit to...	Type...
Unrestricted	U
An absolute value	The value you want to use. For example, to set the low limit to 50, type 50<Enter> in the Override Lo Lim column.
A relative percentage of the calculated value	The percentage of the calculated value you want to use. Be sure to include a percent sign (%) after the percentage. For example, to set the high limit to 10%, type 10%<Enter> in the Override Hi Lim column.
A relative difference from the calculated value	The difference from the calculated value you want to use followed by a minus sign (-). For example, to set the high limit to 10 over the calculated value type 10-<Enter> in the Override Hi Lim column.
Restricted	R

For more information about override limits, refer to the section Spreadsheet Columns.

If you prefer, you can enter the override limits using the Override Limit dialog box. To display this dialog box, double-click a cell in either override limit column.

When the Override Limit dialog box appears, select the appropriate radio button and, if there is a field to the right of the button, use the guidelines in the table Override Limits to enter a value into that field.

See Also