Computer Applications
Explain circular reference with an example.
Spreadsheet
63 Likes
Answer
A circular reference occurs when a formula in a cell refers to its own cell value directly or indirectly. For example, if you enter the formula =A1+A2*3
in cell A2, you are making the formula to refer to its own cell value, which creates a circular reference.
Answered By
41 Likes