KnowledgeBoat Logo
|
LoginJOIN NOW

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


Related Questions