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