Math

Function

Description

Abs(Value)

Returns the absolute value of Value.

Exp(Value)

Returns e raised to the power of Value.

Mod(Value1, Value2)

Returns the remainder of Value1 divided by Value2.

Power(Base, Exp)

Returns Base raised to the power of Exp.

Rand(Event)

Returns a random Number (0.0 to 1.0) on an input Event. Each event triggers a new random number.

Note: Rand must be the only item in the cell.

Round(Value)

Returns Value rounded to the nearest integer.

RoundDown(Value)

Returns Value truncated down to the next-smaller integer.

RoundUp(Value)

Returns Value rounded up to the next-larger integer.

Sqrt(Value)

Returns the square root of Value.

Sum(Value1, [Value2, ...])

Returns the sum of a variable-length list of Values.

Trunc(Value)

Returns Value truncated toward zero to an integer. The result is Value without any fraction.

For more information, see Insert Function Dialog or Mathematics Functions.