A circular reference occurs when a formula in a cell directly or indirectly applies to the cell in which the formula itself is located. Taking this as an example, after entering the formula `=SUM(A1,B1,C1)` in cell C1, a circular reference prompt box will pop up immediately. This is because the formula in cell C1 refers to cell C1 where the formula itself is located. At this time, if you click the close button and change the value no matter what, the result will only be 0, and no prompt box will pop up. Therefore, when we open a table with the prompt box turned off and find that the result does not match the formula, we can click the "Error Checking" drop-down menu under the "Formula" tab. At this time, if the circular reference is in the optional state, it means that there is a "circular reference" cell in the table. If it is in the unselectable state, it means that there is no cell in the table with a "circular reference" formula. But if we want this "circular reference" formula to be established and the result obtained, how should we do it? Step 1: Click the [Options] button under the [File] menu and select Recalculate. Step 2: Check [Iterative calculation] on the recalculation settings page and set the number of times. In this case, it is 2. At this time, the formula results in 6. The operation process first calculates "A1+B1=3", which is the value of C1, and then iteratively calculates C1 to "3+3" to get 6. At this time, if the value of A1 or B1 is changed, the result will be automatically calculated iteratively. Then if the number of iterations is set to 3, the result is "6+3" equals 9, and so on. Note that after resetting the number of iterations, you need to double-click the formula cell and press the enter key to update the results.
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/jie-jue-xun-huan-yin-yong-cuo-wu-chang-jian-tan-chuang-wen-ti-ji-qi-xiu-fu-fang-fa.html
支付宝扫一扫
评论列表（196条）
测试