...
An expression is entered by giving the Edit Expression command on the EDIT menu, or by typing X. The cursor will then move to the editing line, at the top of the screen, until the expression is entered by typing
| Highlight | |||||||
|---|---|---|---|---|---|---|---|
| |||||||
ENTER |
Alternatively, if the Options Page Text/Numbers option is set to N, all entries are taken as expressions.
...
| & | AND | ¦ | OR |
| ! | unary NOT |
Functions
...
ABS | Absolute value |
|---|---|
ABS(number) Returns the absolute positive value of the argument. | |
ACS | Arc cosine |
ACS(number) Returns the arc cosine of the argument, in radians. | |
ASN | Arc |
...
sine | |
|---|---|
ASN(number) Returns the arc sine of the argument, in radians. | |
ATN | Arc tangent |
ATN(number) Returns the arc tangent of the argument, in radians. | |
CHOOSE | Choose element from list |
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 |
...
contains
gives the |
...
result |
COL |
|---|
...
Column | |
|---|---|
COL The value of the column in which it is evaluated. Column A is 1, column B is 2, etc. | |
COS | Cosine |
COS(radians) Returns the cosine of the argument. | |
COUNT | Count the number of elements |
COUNT(list) Returns the number of non-blank slots in the list. | |
DAY | Day of date |
DAY(date) Returns the day number of a date argument. For example, if |
...
slot |
...
contains |
...
then DAY (A1) |
...
returns 17 | |
DEG | Degrees from radians |
|---|---|
DEG(radians) Converts the argument, taken in radians, into degrees. | |
EXP | Exponent |
EXP(number) Returns the constant e (2.71828184..) raised to the specified power. | |
IF | Conditional expression |
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
would return Debit. | |
INDEX | Index slot |
|---|---|
INDEX(column,row) Returns the evaluated expression or string found at coordinates column, row. For example, |
...
if |
...
contained
would |
...
return | |
INT | Integer part |
|---|---|
INT(number) Returns the integer part of the argument. | |
LN | Logarithm to base e |
LN(number) Returns the natural logarithm, loge |
...
of the argument. | |
LOG | Logarithm to base 10 |
|---|---|
LOG(number) Returns the logarithm to base 10 of the argument. | |
LOOKUP | Look up value in a table |
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 |
...
were placed at B4: 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 | Maximum value in list |
|---|---|
MAX(list) Returns the maximum value from the slots in the list. | |
MIN | Minimum value in list |
MIN(list) Returns the minimum value from the slots in the list. | |
MONTH | Month of date |
MONTH(date) Returns the month number of its date argument. For example, |
...
if |
...
contains |
...
then |
...
returns | |
PI | π |
|---|---|
PI Returns the value 3.141592653. | |
RAD | Radians from degrees |
RAD(degrees) Returns the argument, taken as degrees, converted into radians. | |
ROW | Row |
ROW The value of the row in which it is evaluated. | |
SGN | Sign |
SGN(number) Returns -1, 0, or 1 depending on whether the argument is negative, zero, or positive respectively. | |
SIN | Sine |
SIN(radians) Returns the sine of the argument, in radians. | |
SQR | Square root |
SQR(number) Returns the positive square-root of its argument. | |
SUM | Sum |
SUM(list) Returns the sum of the slots in the list. | |
TAN | Tangent |
TAN(radians) Returns the tangent of the argument, in radians. | |
YEAR | Year of date |
Returns the year number of its date argument. For example, |
...
if |
...
contains |
...
then |
...
returns |
@ Fields
You can include the page number, the date, the file title from the Options Page, or the value of any expression slot within text in your document using the special PipeDream @-fields.
...