Apple M9057 User Manual - Page 168
Cell references in formulas, relative reference, absolute reference
UPC - 718908500040
View all Apple M9057 manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 168 highlights
7-22 AppleWorks 5 User's Manual Formulas can be simple or very complex, with many parts. All of these are legitimate (and simple) formulas: This formula =B6+B8 =E9*3.5 =Shares*Price ="California" =SUM(D4..D12) Does this Adds the values in cells B6 and B8 Multiplies the value in cell E9 by 3.5, a constant (fixed value) that you supply Multiplies the values in two named cells (see "Naming cells and ranges" on page 7-12) Places a text constant (California) in a cell Uses the SUM function (a predefined formula) to add the values in the cell range D4 to D12 See "Working with functions" on page 7-26 for more information on functions. Cell references in formulas In the Help index,* see: E cells, references A formula can contain references to a cell or a range of cells. AppleWorks uses the data in the cells to compute the formula's result. There are two types of references: relative and absolute. 1 A relative reference gives the location of a cell relative to the location of the current cell. If you copy and paste a formula with a relative reference to another cell, AppleWorks changes the reference to reflect the relative position from the new source cell. 1 An absolute reference stays the same when you copy and paste a formula. To enter an absolute cell reference, type a dollar sign ($) before each part of the cell address. You can also mix absolute and relative addresses in the same formula (for example, =$A$1+B1). Relative reference Absolute reference The formula in cell A3 is =A1+A2. If you copy the data in cell A3 to B3, the formula becomes =B1+B2. The formula in cell A3 is =$A$1+$A$2. If you copy the data in cell A3 to B3, the formula is still =$A$1+$A$2. * Choose Index from the or Help menu and scroll to the entry. Then choose a topic from the list and click Go To Topic.