Page Comparison

ABS(number)

Returns the absolute positive value of the argument.

ACS(number)

Returns the arc cosine of the argument, in radians.

ASN(number)

Returns the arc sine of the argument, in radians.

ATN(number)

Returns the arc tangent of the argument, in radians.

CHOOSE(list)

Returns an element from the list, using the value of the first element as an index into the remaining elements. For example,

if B4

 contains 17.2.1987

CHOOSE (MONTH(B4),"jan","feb","mar","apr")

gives the

result feb.

COL

The value of the column in which it is evaluated. Column A is 1, column B is 2, etc.

COS(radians)

Returns the cosine of the argument.

COUNT(list)

Returns the number of non-blank slots in the list.

DAY(date)

Returns the day number of a date argument.

For example, if

slot A1

 contains 17.3.1961,

then DAY (A1)

 returns 17

DEG(radians)

Converts the argument, taken in radians, into degrees.

EXP(number)

Returns the constant e (2.71828184..) raised to the specified power.

IF(boolean,then,else)

If the value of the first argument is TRUE, ie non-zero, the function returns then; otherwise the function returns else.

For example, if slot A1

contains -23,

IF(A1 <0,"Debit","Credit")

would return Debit.

INDEX(column,row)

Returns the evaluated expression or string found at coordinates column, row.

For example,

if A2

 contained IF(100,"Debit","Credit")

INDEX(1,2)

would

return Credit.

INT(number)

Returns the integer part of the argument.

LN(number)

Returns the natural logarithm, log_e

 of the argument.

LOG(number)

Returns the logarithm to base 10 of the argument.

LOOKUP(key,range1,range2)

Returns the value in range2 corresponding to the position that key occurs in range1.

key must be a cell reference. For example, the following sheet would result

if LOOKUP(A3,A1 F1,A2 F2)

 were placed at B4:

Image Modified

If an exact match is found in range1, the function returns the value of the slot the same number of slots from the beginning of the second range.

If key is not found in range1, the function returns the error

Lookup

Wildcards '^?' and '^#' may be included in key.

MAX(list)

Returns the maximum value from the slots in the list.

MIN(list)

Returns the minimum value from the slots in the list.

MONTH(date)

Returns the month number of its date argument.

For example,

if A1

 contains 12.6.1987

 then MONTH(A1)

 returns 6.

PI

Returns the value 3.141592653.

RAD(degrees)

Returns the argument, taken as degrees, converted into radians.

ROW

The value of the row in which it is evaluated.

SGN(number)

Returns -1, 0, or 1 depending on whether the argument is negative, zero, or positive respectively.

SIN(radians)

Returns the sine of the argument, in radians.

SQR(number)

Returns the positive square-root of its argument.

SUM(list)

Returns the sum of the slots in the list.

TAN(radians)

Returns the tangent of the argument, in radians.

Returns the year number of its date argument.

For example,

if A1

 contains 12.6.1987

 then YEAR(A1)

 returns 87.