If a formula refers to its own cell directly, or through a chain of references to other cells ultimately refers back to its own cell, you will receive a circular reference warning from Excel.

Microsoft Excel is designed to alert users whenever a circular reference is causing problems. Folks who are unable to spot the error can take full advantage of the ...