Excel Absolute Referencing

Created with Sketch.

Excel Absolute Referencing

Absolute referencing helps multiply multiple values with a particular value.

See the image shown below. The list 1 values are multiplied by 4, value of cell C3. In this case, we will use symbol $ in the formula.

So we have to modify the formula for that after entering the formula press F4 key. $ Sign will appear in the formula. See cell D3 in the image. Then press Enter key to get the result. Now drag the fill handle from cell D3 till cell D10. All values of list 1 will get multiplied with 4.

Excel absolute referencing 1

In a similar way, in the image shown below, the bonus marks are added to the marks of the students by modifying the formula from =C5+E2 to =C5+$E$2.

Excel absolute referencing 2


Leave a Reply

Your email address will not be published. Required fields are marked *

This is a free online math calculator together with a variety of other free math calculatorsMaths calculators