Eval
Eval is a mathematical function that evaluates an expression. Use Eval as an embedded function argument to consolidate multiple expressions into one expression.
Syntax:
Eval(expression)
where expression is one or more of the following values:
| Argument | Description |
|---|---|
|
numeric |
A numeric value. Numeric values can include decimals and negative values. See Numeric Arguments. |
|
row, column, or reference |
A pointer to a row, column, or cell within a grid. References can be specified in several ways. The reference syntax is: |
|
function |
An embedded function. |
|
operators |
Any of the supported arithmetic operators (+, -, *, /, ^, %). |
Example:
Divide row 1 by row 2, and then round the data to four places:
Round(Eval([1]/[2]),4)Note:
In this example, you must use EVAL to get the desired result. The following does not work: Round(([1]/[2]),4).