# Workbook Functions: Arithmetic

ABS(Any number)

Absolute value with sign stripped so abs(1)=1 and abs(-1)=1.

AVERAGE(Number list)

Average (arithmetic mean) of the supplied list.

CEILING(Number, Significance)

Rounds a number up to the nearest multiple of the specified significance, regardless of its sign.

See also: EVEN, FLOOR, INT, ODD, ROUND, TRUNC

EVEN(number)

Rounds the specified number up to the nearest even integer.

See also: CEILING, FLOOR, INT, ODD, ROUND, TRUNC

EXP(Any number)

The mathematical constant e (2.71828183) raised to the specified power.

FACT(Non-negative integer)

Factorial of a specified number.

FIXED(Any number [, precision][,no commas])

Rounds the number to the supplied precision. No commas determines if thousands separators (commas) are used in the result.

FLOOR(Any number, significance)

Rounds a number down to the nearest multiple of a specified significance.

See also: CEILING, EVEN, INT, ODD, ROUND, TRUNC

INT(Any number)

Rounds the number to the nearest integer.

See also: CEILING, FLOOR, MOD, ROUND, TRUNC

LN(positive real number)

Natural (based on the constant e) logarithm.

LOG(positive real number [,base])

Logarithm of the number. Base default value is 10.

LOG10(positive real number)

Base-10 logarithm.

MAX(number list)

Largest value in the specified list of numbers. The list can be a cell range.

MIN(number list)

Smallest value in the specified list of numbers. The list can be a cell range.

MOD(any number, divisor)

Remainder after dividing a number by the specified divisor.

ODD(any number)

Rounds the specified number up to the nearest odd integer.

See also: CEILING, EVEN, FLOOR, INT, ROUND, TRUNC

PI

Returns the value of PI.

PRODUCT(number list)

Multiplies a list of numbers and returns the result.

RAND()

Returns a number selected randomly from a uniform distribution greater than or equal to 0 and less than 1.

ROUND(number, precision)

Rounds the given number to the supplied number of decimal places. A negative precision means that the digits to the right of the decimal point are dropped and the absolute number of significant digits specified by precision are replaced by zeros.

See also: CEILING, FLOOR, INT, MOD, TRUNC, ROUNDDOWN, ROUNDUP

ROUNDDOWN(number, decimal_places)

Rounds the given number down to the specified number of decimal places.

See also: CEILING, FLOOR, INT, MOD, TRUNC, ROUND, ROUNDUP

ROUNDUP(number, decimal_places)

Rounds the given number up to the specified number of decimal places.

See also: CEILING, FLOOR, INT, MOD, TRUNC, ROUND, ROUNDDOWN

SIGN(any number)

Sign of the specified number: 1 if the number is positive, -1 if it is negative and 0 if it is 0.

SQRT(positive number)

Square root of the specified number.

STDEV(number list)

Standard deviation of a population based on a sample of supplied values.

STDEVP(number list)

Standard deviation of a population based on an entire population of values.

SUM(number list)

Sum of the supplied numbers.

See also: AVERAGE, COUNT, COUNTA, PRODUCT, SUMSQ

SUMIF(range, criteria, [sum_range])

Sum of the specified cells that match the given criteria (e.g. ">15"). If sum_range is specified then cells in this range are summed if corresponding cells in range meet the given criteria. If sum_range is omitted then cells in the range that meet the criteria are summed.

See also: AVERAGE, COUNT, COUNTA, COUNTIF, PRODUCT, SUM

SUMSQ(number list)

Squares each of the supplied numbers and returns the sum of the squares.

TRUNC(number [, precision])

Truncates the given number to an integer, with the number of decimal places allowed in the truncated number given by precision (default is 0).

See also: CEILING, FLOOR, INT, MOD, ROUND

VAR(number list)

Variance of a population based on a sample of values.

VARP(number list)

Variance of a population based on an entire population of values.