Workbook Functions A-C

ABS(any number)

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

ACOS(number from 1 to -1)

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

ACOSH(number >=1)

Inverse hyperbolic cosine.

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

ASINH(any number)

Inverse hyperbolic sine.

ATAN(any number)

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

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

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

Inverse hyperbolic tangent.

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.

CHAR(number between 1 and 255)

Character that corresponds to the supplied ANSI code number

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.

CLEAN(text)

Removes all non-printable characters from the supplied text.

CODE(text)

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

COLUMN(reference)

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

COLUMNS(range)

Number of columns in a range of cells.

COS(Any number)

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

COSH(Any number)

Hyperbolic cosine.

COUNT(value list)

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

COUNTIF(range, criteria)

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

COUNTA(expression list)

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