- Image and text skills
Circular reference refers to when a formula in a cell directly or indirectly applies to the cell where the formula itself is located.
▪Take this as an example,InC1 After entering the formula=SUM(A1,B1,C1) into the cell, The circular reference prompt box pops up immediately, This is because C1In the formula in the cellReferences the cell where the formula itself is locatedC1,At this time If you click the close button and change the value no matter what, the result will only be 0, and not A prompt box will pop up.
▪So when we open a closed prompt When you find that the result does not match the formula,you can click the "Formula" option The "Error Checking" drop-down menu under the card. If the circular reference is optional at this time, means that the table memory exists "Circular reference" cell, If it is not selectable, it means the table Inside
There is no cell with a "circular reference" formula,but we want this The formula of "circular reference" is establishedWhat should I do if the result is obtained?
▪Step 1: Click [File] Click the [Options] button under the menu and select Recalculate.
▪Step 2: Recalculate settings Check [Iterative calculation] on the page and set the number of times, This example is 2 ,At this time, the formula results in 6.
The operation process first calculates "A1+B1=3"That is,C1, again Iterative calculation of C1 is "3+3" comes to6.
▪If you change the value of A1 or B1 at this time value, the result will be automatically calculated iteratively.
▪Then if the number of iterations is set to< /span>3, The result is "6+3" is equal to< span style="font-size: 16px;">9, and so on, Note that after resetting the number of iterations,you need to double-click the formula cell,
Press enter 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/chang-jian-cuo-wu-dan-chuang-yu-jie-jue-fang-fa-xun-huan-yin-yong-de-yuan-yin-ji-jie-jue-ban-fa.html
评论列表(196条)
测试