Commodore Plus 4 - Page 148

136
The Built-in Software
The first part of the formula usually contains a comparison operator. Four
comparison operators you can use are shown in Table 2-4.
Table 2-4. Comparison Operators
Symbol Meaning
=
nte
>
<
equal
not equal
greater than
less than
The third part of the NOTIFTRUE formula uses the left-pointing arrow to
assign a value to a cell, which occurs only when the first part of the formula is not
true.
The NOTIFTRUE formula can be used while the cell cursor is in any cell.
However, when the NOTIFTRUE formula is executed, a 0 (when false) or 1
(when true) is placed in the current cell if that cell is not also the destination for the
NOTIFTRUE formula. Therefore, do not issue a NOTIFTRUE when the current
cell contains a value you want to protect.
You can also use the IFTRUE command to check conditions in a formula.
IFTRUE assigns the value in part 3 of the formula only when the calculation in
the first part of the formula is true.
Examples: 8;6 = 9;6 notiftrue 10;6 «- 7;6
S;l
< 4;1 notiftrue 3;1 - #7.5
Assigns the value of cell 7;6 to
cell 10;6 if the entry in 8;6 does
not equal the entry in cell 9;6.
Assigns the number 7.5 to cell
3;1 if the value of cell 2;1 times
0.6 is not less than the entry in
cell 4; 1.
OFF SS
Turns off the MAP command when you are finished transferring rows of
spreadsheet data to the word processor.
Example: off Cancels a MAP command.
RCO SS
Lets you copy the cell entries from one row into another. RCO (Row COpy)
writes a duplicate of all cell entries from the row you are copying into the row