There are two main types of circular reference cells: direct and indirect. A direct circular reference is one where the formula in a cell directly refers back to the same cell. For example, if you put a formula in cell A10 which refers to cell A10 in some way, it’ll produce an error. Indirect references happen when a chain of formulas across different cells refers back to itself at some stage.