Math

Math functions provide arithmetical functions for the specified spreadsheet cell or the data it holds.

Function	Description
Abs(Value)	Returns the absolute value of Value.
Exp(Value)	Returns e raised to the power of Value.
Int(Val)	Returns the specified value (Val) rounded down to the next smaller integer. This function works the same as the RoundDown function.
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.