Numeric functions – Apple Numbers '08 User Manual
Page 200
200
Chapter 12
Dictionary of Functions
Numeric Functions
The numeric functions calculate commonly used mathematical values.
Numbers provides these numeric functions.
Function
Description
Calculates the absolute value of a number.
Rounds a number away from zero to the nearest multiple of a
specified factor.
Finds the number of different ways you can combine a number of
items into groups of a specific size.
Rounds a number away from zero to the next even number.
Calculates e to the power of a number.
Calculates the factorial of a number.
Rounds a number toward zero to the nearest multiple of a
specified factor.
Calculates the greatest common divisor of a set of numbers.
Returns the nearest integer less than or equal to a number.
Finds the least common multiple of a set of numbers.
Calculates the natural logarithm of a number.
Calculates the logarithm of a number with a specified base.
LOG10 (page 245)
Calculates the base-10 logarithm of a number.
Calculates the remainder of a division.
Rounds a number to the nearest multiple of a specified factor.
Rounds a number away from zero to the nearest odd number.
Returns an approximation of pi accurate to 15 decimal places.
Raises a number to a power, like the ^ operator.
Calculates the product of a set of numbers.
Calculates the integer quotient (without remainder) of two
numbers.
Generates a random number greater than or equal to 0 and less
than 1.
RANDBETWEEN (page 264)
Generates a random integer in an inclusive range.
Converts a number to Roman numerals.
Rounds a number to a specified number of digits.
ROUNDDOWN (page 268)
Rounds a number toward zero to the specified number of places.
Rounds a number away from zero to the specified number of
places