Circular Reference in Excel - Easy Excel Tutorial http://www.excel-easy.com/examples/circular-reference.
html
Excel Easy
#1 Excel tutorial on the net Excel Introduction Basics Functions Data Analysis VBA 300 Examples Ask us
Circular Reference
A formula in a cell that directly or indirectly refers to its own cell is called a circular reference. This is not possible.
Chapter
1. For example, the formula in cell A3 below directly refers to its own cell. This is not possible.
Formula Errors
Learn more, it's easy
IfError
IsError
Circular Reference
Formula Auditing
Floating Point Errors
Download Excel File
circular-reference.xls
Follow Excel Easy
Note: Excel returns a 0 if you accept this circular reference.
1 of 4 08-11 06:17 PM
Circular Reference in Excel - Easy Excel Tutorial http://www.excel-easy.com/examples/circular-reference.html
2a. For example, the formula in cell C2 below refers to cell C1.
2b. The formula in cell C3 refers to cell C2.
2c. The formula in cell C4 refers to cell C3.
2d. So far, everything's OK. Now change the value in cell C1 to the formula =C4. Cell C1 refers to cell C4, cell C4
refers to cell C3, cell C3 refers to cell C2, and cell C2 refers to cell C1. In other words, the formula in cell C1
indirectly refers to its own cell. This is not possible.
2 of 4 08-11 06:17 PM
Circular Reference in Excel - Easy Excel Tutorial http://www.excel-easy.com/examples/circular-reference.html
Note: Excel returns a 0 if you accept this circular reference.
3. To find your circular references, on the Formulas tab, click the down arrow next to Error Checking, and click
Circular References.
3 of 4 08-11 06:17 PM
Circular Reference in Excel - Easy Excel Tutorial http://www.excel-easy.com/examples/circular-reference.html
Bloomberg India
Analyze India F & O Market Contact us for a Demo today !
Be Certified in Big Data
Naeem Carbon Brushes,
Download Now
Invest Smartly in Market
Salary & Payroll Software
Jaguar XF @Rs.48.51 Lacs*
Start Download
Free IT Training
Class 1 to Class 12
Do you like this free website? Please follow us on Google+
Learn more about formula errors, use the side menu >>
Go to Top: Circular Reference | Go to Next Chapter: Array Formulas
COPYRIGHT (C) 2010-2015 WWW.EXCEL-EASY.COM. ALL RIGHTS RESERVED.
EXCEL 2010 TUTORIAL | HOW TO EXCEL | MICROSOFT EXCEL 2010 | EXCEL MACRO
4 of 4 08-11 06:17 PM
