![]() However, since they don't directly refer to themselves, they're indirect circular references. Lastly, select cell C1 on the formula bar and replace 20 with the line below: =E4+1Īs expected, Excel returns 0 because these cells refer to each other in a circle. ![]() And now you're probably saying, 'Hang on, a last calculated value' Yes. When you close the message, Excel displays either a zero or the last calculated value in the cell. The first time Excel finds a circular reference, it displays a warning message.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |