Eval
Eval is a mathematical function that evaluates an expression. You use Eval as an embedded function argument to consolidate multiple expressions into one expression. The function syntax:
Eval(expression)
where expression is one or more of these arguments:
Argument | Description |
---|---|
numeric |
A numeric value. Numeric values can include decimals and negative values. |
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: |
function |
An embedded function |
operators |
Use any of the supported arithmetic operators (+, -, *, /, ^, %, and so on). |
Example
The following example divides row 1 by row 2 and then rounds the data to four places:
Round(Eval([1]/[2]),4)