Predefined formulas |
Groups all predefined formulas according to the element
you want to associate with a formula. To replace the
existing formula, select the formula and click
Replace formula. You can also
modify this formula manually. A message notifies you when
the formula is invalid. |
Recent formulas |
Displays the formulas that you have used recently. To
replace the active formula, select an existing formula and
click Replace formula. |
Variables and simple formulas
|
Lets you create your own formula.
- Simple formula. Displays the list of variables
available and simple formulas using these
variables.
- Description. Gives you a description of the selected
variable.
- Type. Displays the variable
type to help you use specific functions such as
VAL or
STRZ.
- Add a simple formula. To
create the formula, select the variable and click
Add a simple
formula.
You can add text but it
must be between quotes ("TEXT") and each text and
variable must be separated by the sign
+. A message notifies you
when the formula is invalid.
|
Functions |
Lists all the functions and operators that you can use in
the formula.
- Function. Displays the
function name. Functions are sorted by type,
mathematical, text, and various functions.
- Description. Displays the
function description (definition).
- Example. Displays an example
of the function use and its syntax. At the end of
the example, you can find the result of the
function.
Click Add a
function to add the function to the
formula.
|