Apple numbers User Manual

    Dictionary of Functions 

 

Numeric Functions 

The numeric functions calculate commonly used mathematical values.

Numbers provides these numeric functions.

Calculates the absolute value of a number.

Rounds a number away from zero to the nearest multiple of a 
specified factor.

COMBIN (page 215)

Finds the number of different ways you can combine a number of 
items into groups of a specific size.

EVEN (page 229)

Rounds a number away from zero to the next even number.

Calculates e to the power of a number.

FACT (page 230)

Calculates the factorial of a number.

FLOOR (page 232)

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.

LCM (page 243)

Finds the least common multiple of a set of numbers.

Calculates the natural logarithm of a number.

LOG (page 245)

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.

POWER (page 258)

Raises a number to a power, like the ^ operator.

Calculates the product of a set of numbers.

QUOTIENT (page 263)

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