Functions Tab - Calculation Editor Dialog

Functions usually have the format:

Function(expression 1, expression 2, expression 3, ...)

An expression is any combination of values (including CLP codes ), variables or operators that yield a single value when evaluated. The number of expressions used in a function can vary depending on the function, though most usually need at least one.

As you look at the functions listed, param 1, param 2 denote required expressions, and opt 1, opt 2 denote optional expressions you can add to the function calculation.

Calculation

The box displays the working version of the calculation. Note: Click the word "Calculation" to open the Calculation Explorer window.

Calculation Result =

The cell contents resulting from the calculation are shown.

Function Categories

Select a category of functions to display in the Functions box. As you click on each function, information about it will be displayed in the description box at right. To see the detailed help topic for the function, click the question mark button above the description box.

A full listing of cell functions may be found under the Cell Function Index.

  

Note

 

To insert a logical function into the calculation at the cursor point, such as a bracket or plus sign, click the appropriate button.

File

Click the File button to insert a file path into the calculation. The path will be contained in quotes, as required by calculations.

When you click File, the Open dialog will appear allowing you to browse to the target file. Select the target file and click Open. The file path will be automatically inserted into the calculation at the cursor point.

Related Topics