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-2019 StatsDirect Limited, all rights reserved. Download a free trial here.