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

EVEN(number)

Rounds the specified number up to the nearest even integer.

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.

INT(Any number)

Rounds the number to the nearest integer.

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.

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.

ROUNDDOWN(number, decimal_places)

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

ROUNDUP(number, decimal_places)

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

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.

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.

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

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.