:Common error pop-ups and solutions Causes and solutions of circular references-Table skills免费ppt模版下载-道格办公

Common error pop-ups and solutions Causes and solutions of circular references

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.

分界线.png

▪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.

录制_2021_06_17_09_38_30_709.gif

▪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?

录制_2021_06_17_09_39_15_698.gif

▪Step 1: Click [File] Click the [Options] button under the menu and select Recalculate.

录制_2021_06_17_09_39_46_419.gif

▪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.

录制_2021_06_17_09_40_18_34.gif

▪If you change the value of A1 or B1 at this time value, the result will be automatically calculated iteratively.

录制_2021_06_17_09_40_44_673.gif

▪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.

录制_2021_06_17_09_41_18_930.gif

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