Workbook Functions A-C
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
Inverse hyperbolic cosine.
See also: ASINH, ATANH, COSH
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
Inverse hyperbolic sine.
See also: ACOSH, ASIN, ATANH, SINH
Arctangent of X in radians from -PI/2 to PI/2 (*180/PI to convert to degrees)
See also: ATAN2, ATANH, PI, TAN
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 (arithmetic mean) of the supplied list.
See also: MIN, MAX
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
Removes all non-printable characters from the supplied text.
See also: CHAR, TRIM
Numeric code of the first character in the supplied string of text.
See also: CHAR
Column number of the supplied reference to a cell or range.
See also: COLUMNS, ROW
Number of columns in a range of cells.
See also: COLUMN, ROWS
Cosine of an angle in radians (*PI/180 to convert the angle from degrees to radians).
See also: ACOS, ASINH, ATANH, COSH, PI
See also: ASINH, ATANH, COS
Counts the number of values in a list containing only numbers or numerical values.
See also: AVERAGE, COUNTA, SUM
Counts the number of cells within a range that match the given criteria (number, expression or text).
See also: AVERAGE, COUNTA, SUM, SUMIF
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