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

 

 

Copyright © 2000-2016 StatsDirect Limited, all rights reserved. Download a free trial here.