Commodore Plus 4 - Page 147

Section 3. Spreadsheet Commands 135
Using MAP to Transfer Long Cell Entries
When you first enter data into a cell, you can enter up to 36 characters per cell, but
only 11 characters are displayed. Extra characters are held in memory and are
displayed on the command line when you enter the cell. MAP sends these extra
characters, including long formulas. In contrast, BLKMAP transfers only 11
characters per cell.
Turning OFF the MAP Command
The OFF command lets you stop the MAPping procedure. You can also termi
nate MAP by switching to the word processor.
Issuing Other Commands During a MAPping Procedure
Unless you terminate MAP by using the OFF command or by leaving the
spreadsheet, MAPping remains in effect. You can issue other spreadsheet com
mands during MAPping without turning MAP off. You can also make changes
in cell entries during a MAPping procedure without interrupting the transfer
process. The changed cell entry is MAPped to the word processor.
Example: map Turns on cell MAPping.
off Turns off cell MAPping.
NOTIFTRUE
Checks the condition of part of a formula. NOTIFTRUE lets you make cell
entries based on conditions in other cells. For example, if you are figuring a
budget, you can put an amount of money into the savings column IF it is NOT
TRUE that income minus expenses for the month is a negative number.
The NOTIFTRUE formula is a compound command consisting of the
following:
1. The first part contains the calculation whose outcome is checked by
NOTIFTRUE.
2. The NOTIFTRUE command is typed next.
3. The final part is the assignment of a value to a cell, which is executed ONLY
when the condition in the first part is not met.