# Unit 18: Formula Referencing

## Absolute Referencing

#### There will be times however when one or more cell references in a formula are always required to be located in a specific cell, row, or column. In the example below, sales tax of 10% is located in cell B4 and must always be referenced from B4. The sales tax for dining table is calculated using the formula =B8*B4 while the sales tax for the sofa is calculated using the formula =B9*B4. These are different shapes and if you were to copy the formula from C8 (=B8*B4) to C9 it would copy the shape and the formula would be =B9*B5 – which is wrong. When dealing with cells in formulas that must be referenced from the same location, you must fix these cell references by making them absolute. This is done by placing a \$ sign in front of either or both the row and column co-ordinate of the cell depending on which of these has to remain fixed (e.g. \$B\$4, \$B4, or B\$4). In the example above, both row and column co-ordinates need to be fixed and the formula in C8 should be written as =B8*\$B\$4 before it can be copied to adjacent cells.

UNIT 18 – Formula Referencing

There aren't any posts currently published in this category.