Local variables are most often used with Assignment functions, which can assign expressions to local variables that are used in a complex equation. (For details, see Assignment Functions in Formula Functions Reference.) This technique can sometimes simplify building an equation and improve the efficiency of its evaluation.
3.
|
In the middle pane of the Formula Editor, select Local Variables from the list.
|
4.
|
Click New Local.
|
5.
|
Enter a name for the local variable. By default, local variables have the names t0, t1, and so on, and have missing values.
|
7.
|
•
|
•
|
You can also create a local variable from an expression. Right-click the expression in the Formula Editor and select Create Local Variable from Expression.
|
See Use Local Variables in a Formula for an example of referencing local variables in a formula.