Circular references introduction

Circular references – results when one of the cells you are referencing in the formula is the cell in which you want the formula to appear.

To make difference from reference relative and absolute reference you willl just look above and jus think if you want the line to be constant you will add $ or variable you will not add the symbol $.

Same if you look at right just think if you want that the column must be constant or variable. For constant you will add $ sign.

A cell is formed by a line and a column is the intersection of those 2.

Good tutorials about circular references in excel:

Troubleshoot circular references errors above is this tutorial from ofzen:

Good habit:

Very good tutorials from jkp: