Use the rules to set up a specific fixed or calculated value for the variable. The calculations are performed every time that the variables in the calculation are changed.
-
Repeat the first six steps described in the Create validation rule.
-
Select the tab.
-
In the field, select the variable name.
-
If the selected variable belongs to the array group, type its index in the field.
-
In the field, select one of the following:
-
– If you want the variable to receive a specific value.
-
– If you want the variable value to be calculated according to a specific formula.
-
-
If you selected , select one of the variable's values in the field. If you selected , click to create a formula.
-
Select the check box if you want all the rules that contain the selected variable to be recalculated.