...
The relational operators can compare dates, strings, and numbers. Both operands must be of the same type, and the result is a logical value of FALSE=0 and TRUE=1.
| << | less than | =<> | less thanequal to | ||
| <= | less than or equal to | > | greater than | ||
| <> | not equal to | => | = | equal togreater than or equal to |
When strings are being compared, the following wildcards (as in the Replace command) can be included in the second string:
| ^? ^# ^^ | matches any single character |
| ^# | matches any number of characters |
| ^^ | represents ^ |
Logical
The logical operators operate on numeric or logical values. Boolean FALSE is taken as zero, TRUE as non-zero.
| & | AND | ¦ | OR | |
| ! | ANDunary NOT | ¦OR |
Functions
ABS Absolute value
...
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 Column
COL
The value of the column in which it is evaluated. Column A is 1, column B is 2, etc.
...
Returns the day number of a date argument.
For example, if slot A1 contains 17.3.1961, then DAY (A1) returns 17
DEG Degrees from radians
...
For example, if slot A1 contains -23,
IF(A1 <0,"Debit","Credit")
would return Debit.
INDEX Index slot
...
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 Integer part
INT(number)
...
key must be a cell reference. For example, the following sheet would result if LOOKUP(A3,A1 F1,A2 F2) 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.
...
Returns the month number of its date argument.
For example, if A1 contains 12.6.1987 then MONTH(A1) returns 6.
PI π
PI
Returns the value 3.141592653.
...
Returns the year number of its date argument.
For example, if A1 contains 12.6.1987 then YEAR(A1) returns 87.
@ 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.
The following @ fields are available:
| Identifier | Effect |
| @P@@D@ @T@ @ref@ @@ | current page number |
| @D@ | date |
| @T@ | title defined in options page |
| @ref@ | value of slot ref |
| @@ | @ |
One or more '@' characters should be given after the identifier to determine the size of the @ field for formatting. For example,
...
If it is an expression slot, the value will be displayed in the same format as in the slot itself, with alignment ignored.
When the cursor is not on a text slot with an @ field in it, the slot shows the value of the @ field. When the cursor is moved onto the slot, the actual @ identifier is shown, for editing.
,
value of slot ref