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.
function	An embedded function. See Mathematical Functions.
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).