Simplifying complex formulae using local variables
You can simplify complex formulae by defining one or more "local variables" in your formulae. A local variable stores a part of a formula which can then be reused any number of times in the body of the formula, saving you from having to enter the information multiple times.
Each local variable must be defined in a statement at the start of the formula comprising the word "Let", the name of the variable, an equal sign and the expression, terminated with a semicolon. You cannot use a reserved word such as "let", "low", "true" or "try" as the name of a local variable. Place local variable statements at the start of your formulae.
For example, the following formula:
can be written more simply by using Let to define a local variable, as illustrated below:
