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)
.