Round reference iteration in Excel permits a cell to confer with its personal worth in a calculation. This may be helpful for creating recursive calculations, akin to calculating the sum of a variety of cells that features the cell itself. To make use of round reference iteration, you need to first allow it within the Excel Choices dialog field. As soon as it’s enabled, you possibly can create a round reference by coming into a method that refers back to the cell itself. For instance, the next method calculates the sum of the vary A1:A10, together with the worth in cell A1 itself:
=SUM(A1:A10)
