Page 25 - Chinmaya_C6_flipbook
P. 25
RELATIVE CELL REFERENCING
In relative cell reference, you actually refer to the cell that is above
or below and left or right to a number of rows or columns. When a To calculate total
number of adjacent
formula is copied to a new location in a worksheet, the value in the cells:
copied cell also changes. Short key
For example, a formula (=A2*B2) placed in cell C2 multiplies the Alt + =
values of cells A2 and B2. As we press the Enter key, the result of the
multiplication of values in A2 and B2 is displayed in cell C2.
If we copy the formula (=A2*B2) in cell C3, then the cell references in the formula (=A2*B2) change
in relation to the new location of the formula, and the result is displayed according to the changed
cell reference.
After copying and pasting the formula in cell C3,
Result of formula (=A2*B2) in cell C2 cell references are automatically adjusted.
ABSOLUTE CELL REFERENCING
In absolute cell referencing, cell references in the Typing the formula (=$A$2 * $B$2)
formula remain the same even if we copy and paste the in cell C2 for absolute referencing
formula to a new location. It is used when you maintain
the original references as they were. For this, we need
to use the $ (dollar) sign as a prefix before the column
name and row number in the formulas.
For example, if we want the value of A1 to be constant
when multiplying it with a cell from column B, absolute
referencing will be used.
When the formula (=$A$2*$B$2) in cell C1 is copied
and pasted to C2, the values in cells A2 and B2 remain Displaying constant result after copying
unchanged. and pasting formula in cell C3
Formulas and Functions in Excel 2016 23

