ABS(any number)

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

See also: SIGN

ACOS(number from 1 to -1)

Arc cosine of X in radians from 0 to PI (*180/PI to convert to degrees).

See also: COS, PI

ACOSH(number >=1)

Inverse hyperbolic cosine.

See also: ASINH, ATANH, COSH

AND(logical list)

True if all arguments are true, false if at least one is false.

e.g. AND(A1+B1>5, A1+C1<10) true if A1=4, B1=2 and C1=5, false if C1=6.

ASIN(number from - 1 to 1)

Arc sine of X in radians from -PI/2 to PI/2 (*180/PI to convert to degrees).

See also: ASINH, PI, SIN

ASINH(any number)

Inverse hyperbolic sine.

See also: ACOSH, ASIN, ATANH, SINH

ATAN(any number)

Arctangent of X in radians from -PI/2 to PI/2 (*180/PI to convert to degrees)

See also: ATAN2, ATANH, PI, TAN

ATAN2(x-coordinate, y-coordinate)

Angle (arctangent), in radians from -PI to PI excluding -PI, formed by the x-axis and a line with end points (0,0) and the given (x,y).

See also: ATAN, ATANH, PI, TAN

ATANH(number from -1 to 1, excluding -1 and 1)

Inverse hyperbolic tangent.

See also: ACOS, ASINH, TANH

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

CHAR(number between 1 and 255)

Character that corresponds to the supplied ANSI code number

See also: CODE

CHOOSE(index, item list)

Value, from a list of items, indicated by the supplied index number. The index number can also be a cell reference or a formula that returns a value from 1 to 29.

See also: INDEX

CLEAN(text)

Removes all non-printable characters from the supplied text.

See also: CHAR, TRIM

CODE(text)

Numeric code of the first character in the supplied string of text.

See also: CHAR

COLUMN(reference)

Column number of the supplied reference to a cell or range.

See also: COLUMNS, ROW

COLUMNS(range)

Number of columns in a range of cells.

See also: COLUMN, ROWS

COS(Any number)

Cosine of an angle in radians (*PI/180 to convert the angle from degrees to radians).

See also: ACOS, ASINH, ATANH, COSH, PI

COSH(Any number)

Hyperbolic cosine.

See also: ASINH, ATANH, COS

COUNT(value list)

Counts the number of values in a list containing only numbers or numerical values.

See also: AVERAGE, COUNTA, SUM

COUNTIF(range, criteria)

Counts the number of cells within a range that match the given criteria (number, expression or text).

See also: AVERAGE, COUNTA, SUM, SUMIF

COUNTA(expression list)

Number of non-blank values in the supplied list of expressions, e.g. COUNTA(32, 45, "Earnings", " ") returns 4.

See also: AVERAGE, COUNT, PRODUCT, SUM

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