Manual

Absolute references

II B r

I s O.OS

An absolute reference tells Spreadsheet the specific address of a ceg. An

absolute reference is like telling someone your exact address: 3628 Sixteenth

Avenue. When you copy a formula from one location to another, Spreadsheet

does not adjust absolute references. Use an absolute reference when you

want to refer to the same cell, regardless of where you may copy the formula

in the spreadsheet. (For detaiis on copying formulas, see page 95.)

For example, when performing financial calculations, you might want to refer

to a specific cell containing an interest rate; for example, 8% in cell B3. When

you want to copy the formula, the reference to cell B3 must not change.

Otherwise each calculation would be based on a different interest rate. To

ensure that all copies of the formula use the value in cell B3, you enter the

absolute reference $1153. (For more information on the financial function, see

Using Built-in Functions in Formulas on page 88. Also see the Appendix for a

listing of the financial functions.)

REFERENCE TYPE

B3 Relative

reference

$B_ A_,aut,

reference

Relative

B$3 column,

absolUte-r_w

Absolute

$83 €olumn,

R,4ativerow

To enter an absolute reference, enter the address with a dollar sign before the

column and/or row indicators. B3 is a relative reference. $B$3 is an absolute

reference, with both the column and the row absolute. You can also create

hybrid references making either the column or row absolute and the other

relative, as shown in the table on the left.

Spreadsheet 87