Absolute
Cell References
We
have looked at the important property of spreadsheets to be able
to copy formulae whilst retaining the relevance of the cell references.
Copying formulae across columns or up and down rows will automatically
change the formulae depending upon the column(s) and/or row(s)
they are copied to.
Under
certain conditions the spreadsheet user will wish to copy formulae
without changing the column or row reference. This is achieved
by giving the cell an Absolute cell reference. Placing a $ symbol
in front of a column reference, eg. $A1 stops the column reference
from changing, whereas, placing it in front of a row reference,
eg. A$1 stops the row reference from changing.
To
ensure that no properties of the cell reference change you need
to place $ in front of the column reference, and $ in front of
the row reference, eg. $A$1. Considering the impact of National
Insurance (NI) will look at this property on the employees in
Payroll example 2:
- Insert
a new column between Tax and Net Pay by clicking Insert on the
Menu Bar and then selecting Columns from the drop-down menu.
- Enter
the title NI in cell H5.
- Insert
a row below Basic Rate of Tax.
- Enter
National Insurance in cell B4 and 6% in cell D4.
- Enter
the formula for Gross Pay * National Insurance in cell H6.
- Ensure
the cell reference for National Insurance (D4) is made absolute,
ie. $D$4.
Contents:
Spreadsheets
Skill
Check: Spreadsheets
|