4.
Explain circular reference with an example.
Answers
Answered by
7
Answer:
A formula in a cell that directly or indirectly refers to its own cell is called a circular reference. ... For example, the formula in cell A3 below directly refers to its own cell. This is not possible. Note: Excel returns a 0 if you accept this circular reference.
Answered by
1
Answer:
Circular references also occur in spreadsheets when two cells require each other's result. For example, if the value in Cell A1 is to be obtained by adding 5 to the value in Cell B1, and the value in Cell B1 is to be obtained by adding 3 to the value in Cell A1, no values can be computed.
Attachments:
Similar questions