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 is:

Eval(expression)

where expression is expressed by one or more of the following arguments:

Argument

Description

numeric

A numeric value. Numeric values can include decimals and negative values. For a description of numeric arguments, 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: GridName.GridElement[segment(range)].Property

For more information, see Row, Column, or Cell Reference Arguments.

function

An embedded function. For a list of mathematical functions, see Mathematical Functions.

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 4 places:

  Round(Eval([1]/[2]),4)