- Picture and text skills
I encountered a calculation result error during table calculation. The result data was inconsistent with the conditional data. I was prompted that there was a circular reference in the cell memory. How to solve it?
▪ As shown in the table, C1= A1+B1, but obviously the result of 3+4 is wrong,This is because the calculation method in this table is manual calculation, You need to save to get the correct answer.Take this as an example,If you need to change this calculation method,Click the [Options] button in the [File] menu,Select [Recalculate] in the pop-up [Options] dialog box, Enter the settings page and check automatic calculation.At this time, change any unit of A1 or B1 The correct answer will be obtained immediately for the content of the grid.
▪ was prompted that there is a circular reference in the cell memory, When the circular reference prompt box appears when opening the table,Indicates that there is a circular reference in a certain cell
Circular reference refers to when a formula in a cell is applied directly or indirectly When the cell itself is located, is called a circular reference
Take this as an example,Enter the formula =sum(A1+B1)+ in cell C1 After C1, a circular reference prompt box pops up immediately, then we still want this How to set up the formula and get the result?
▪ 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 ,This example is 2, the result is 5.3,The operation process is calculated first Find A1+B1=2.65, which is the value of C1,Then iteratively calculate C1, which is 2.65+2.65 and get 5.3,If the number of iterations is set to 3,The result is 5.3+2.65 equals 7.95, and so on,< /span>Note that to update the data results, you need to double-click the formula cell and press Enter.
▪ Xiao Li When calculating data, it is found that the result data and the conditional data are inconsistent.What should I do?
▪ Step 1: Click the [Options Button] under the [File] menu and select Recalculate .
▪ Step 2: Check [Subject to display accuracy] on the recalculation settings page checkbox,click OK, and the result data will be calculated according to the accuracy of the conditional data.
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/qiao-yong-chong-xin-ji-suan.html
评论列表(196条)
测试