Using spreadsheet cell references in formulas

    A spreadsheet can automatically recalculate formulas when data changes. To do this, you use references (addresses) of other cells in a formula. When you alter the data in a referenced cell, AppleWorks automatically recalculates the formula using the new data.

    You can also use references to cells and spreadsheet frames in other AppleWorks documents.

    To include cell references in a formula:
    1 Click in the entry bar where you want to include a cell reference.
    2 Add a cell reference using one of these methods:
    • For a single cell, click the cell or type its address.
    • For a range of cells, drag through the range of cells, or type the address of the upper-left cell, two periods, and the address of the lower-right cell (for example, A3..C8).
    • Type the name of a named cell range or choose it from the name pop-up menu (to the left of the entry bar).
    If you're using multiple cell references in a single formula:
    • Enter an operator before each selection. (If you don't enter an operator, AppleWorks inserts a plus sign.)
    • Separate the references with commas. For example, the formula =AVERAGE(A12,C3,D2..D8) returns the average of the values in cells A12, C3, and the range of D2 through D8.

Including references to cells in other spreadsheet documents or frames

    Note: A document or frame name must be enclosed in quotation marks if it contains spaces, special characters, or resembles a cell address or function name.

    To enter a reference to a cell in another spreadsheet:
    • Type the document name, an exclamation point (!), and the cell address.
    For example:
    • =Budget.CWK!A2
    • =SUM("Planning Budget"!A2..A31)

    To reference a spreadsheet frame in the current document or another document, you must first name the frame:
    1 Select the frame.
    2 Choose Frame Info from the Edit menu.
    3 Type a name.

    To enter a reference to a cell in a spreadsheet frame in the current document:
    • Type the frame name in brackets, an exclamation point, and the cell address.
    For example: =[West_Region]!A2

    To enter a reference to a cell in a spreadsheet frame in another document:
    • Type the name of the document, the name of the frame (in brackets), an exclamation point, and the cell address.
    For example: ="Budget 1"[West_Region]!A2

Related topics

 
Table of contents | Index