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. |