Workbook Functions: Arithmetic
ABS(Any number)
Absolute value with sign stripped so abs(1)=1 and abs(-1)=1.
See also: SIGN
AVERAGE(Number list)
Average (arithmetic mean) of the supplied list.
See also: MIN, MAX
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.
See also: LN, LOG
FACT(Non-negative integer)
Factorial of a specified number.
See also: PRODUCT
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.
See also: DOLLAR, ROUND, TEXT, VALUE
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.
See also: EXP, LOG, LOG10
LOG(positive real number [,base])
Logarithm of the number. Base default value is 10.
See also: EXP, LN, LOG10
LOG10(positive real number)
Base-10 logarithm.
See also: EXP, LN, LOG
MAX(number list)
Largest value in the specified list of numbers. The list can be a cell range.
See also: AVERAGE, MIN
MIN(number list)
Smallest value in the specified list of numbers. The list can be a cell range.
See also: AVERAGE, MAX
MOD(any number, divisor)
Remainder after dividing a number by the specified divisor.
See also: INT, ROUND, TRUNC
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.
See also: COS, SIN, TAN
PRODUCT(number list)
Multiplies a list of numbers and returns the result.
See also: FACT, SUM
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.
See also: ABS
SQRT(positive number)
Square root of the specified number.
See also: SUMSQ
STDEV(number list)
Standard deviation of a population based on a sample of supplied values.
See also: STDEVP, VAR, VARP
STDEVP(number list)
Standard deviation of a population based on an entire population of values.
See also: STDEV, VAR, VARP
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.
See also: SUM
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.
See also: STDEV, STDEVP, VARP
VARP(number list)
Variance of a population based on an entire population of values.
See also: STDEV, STDEVP, VAR