Buzz
Have you mastered the application of absolute and relative addresses for calculations in Excel? Explore the examples provided by Mytour to understand the differences between the two.
Absolute and Relative Addresses in Excel
Example of calculating the circumference of a circle
To find the circumference of a circle, we use the formula Circumference=3.14* diameter. In the table, three columns are arranged to store values.
Enter the value of pi in the cell with the position C7 and the diameter extends from D7 to D16.
Perform the calculation result into cell E7 using the command =D7*C7 to calculate the circumference of the circle, and we immediately get the result as 3.14.
Dragging down values from cell E7 to E16 results in all zeros because B8 -->B16 have no values.
So how do we calculate the circumference of circles for lower diameters without filling in Pi values from B8 to B16?
In the cell containing the first calculation, add the character “$” on both sides of the letter, meaning the row symbol of the referenced cell, here is position E7--> =D7*$E$7.
Drag the mouse down to copy the formula, check the results after adding $E$ to the reference position, and observe the difference in the results below. That's how you perform the calculation of the circumference of circles in this example.
In this context, the position C7 is referred to as the relative address, and the values from E7 to E16 are called absolute addresses in this table.
Here, we've shared with you the concepts of relative and absolute addresses in Excel. This way, you can apply them to perform calculations in Excel using this approach.
