Apple AppleWorks 5 : Mac OS - Manual (Page 171)

Spreadsheet 7-25
Making corrections
If you see ### in a cell, it means the column is too narrow to display the
number. To widen the column, select the column and then increase its width
by choosing Column Width from the Format menu. Type a width, and then click
OK. For more information on changing the size of a column, see “Resizing or
hiding rows and columns” on page 7-17.
AppleWorks tells you if it can’t evaluate a formula you’ve entered. Error
messages start with the symbol # and end with an exclamation point (!), or
you may see a message on the screen. Check your formula for the correct
placement of parentheses, be sure parentheses are correctly paired, and
check to see that you have entered operators between the cell references. For
more spreadsheet and formula tips, see onscreen Help.
Examples: Entering formulas
These examples show how to use formulas to add numbers.
Example 1: Simple arithmetic
To enter a formula that sums three numbers:
1. Click a cell to make it active.
2. Type =12+3-5 in the entry bar.
3. Click to confirm the entry.
AppleWorks sums the numbers and displays the result, 10, in the cell.
Tip To total the value quickly, select the cells and click on the Default
button bar.
Example 2: Using cell references
To sum three numbers using cell references:
1. Type 75 , 150 , and 725 as shown here.
* Choose Index from the or Help menu and scroll to the entry. Then choose a topic from
the list and click Go To Topic.
In the Help index, * see:
E
formulas, spreadsheet
E
resizing, spreadsheet cells
E
troubleshooting
Before After
Error messages