Circular reference errors occur when a formula refers baông xã to lớn its own cell. For example, in the example shown, the formula in F7 is:
To resolve circular references, you"ll need khổng lồ find the cell(s) with incorrect cell references và adjust as needed. The article below provides more information và steps to lớn resolve.
Bạn đang xem: Circular reference in excel
Circular reference errors occur when a formula refers baông chồng to lớn its own cell. For example, in the example shown, the formula in F7 is:
This creates a circular reference because the formula, entered in cell F7, refers to F7. This in turn throws off other formula results in D7, C11, & D11:
=F7 // formula in C7=SUM(B7:C7) // formula in D7=SUM(C5:C9) // formula in C11=SUM(D5:D9) // formula in D11
Circular references can cause many problems (& a lot of confusion) because they may cause other formulas lớn return zero, or a different incorrect result.
The circular reference error message
When a circular reference occurs in a spreadsheet, you"ll see a warning lượt thích this:
"There are one or more circular references where a formula refers to lớn its own cell either directly or indirectly. This might cause them lớn calculate incorrectly. Try removing or changing these references, or moving the formulas to lớn different cells."
This warning will appear sporadically while editing, or when a worksheet is opened.
Xem thêm: Cách Gộp Nhiều File Word Thành 1 File, Cách Hợp Nhất Tài Liệu Word Bằng Một Click
Finding and fixing circular references
To resolve sầu circular references, you"ll need to lớn find the cell(s) with incorrect cell references và adjust as needed. However, unlượt thích other errors (#N/A, #VALUE!, etc.) circular references don"t appear directly in the cell. To find the source of a circular reference error, use the Error Checking thực đơn on the Formulas tab of the ribbon.
Select the Circular References item khổng lồ see the source of circular references:
Below, the circular reference has been fixed & other formulas now return correct results: