Circular references – results when one of the cells you are referencing in the formula is the cell in which you want the formula to appear.

To make difference from reference relative and absolute reference you willl just look above and jus think if you want the line to be constant you will add $ or variable you will not add the symbol $.

Same if you look at right just think if you want that the column must be constant or variable. For constant you will add $ sign.

**A cell** is formed by a line and a column is the intersection of those 2.

Good tutorials about circular references in excel:

http://chandoo.org/wp/2010/09/16/excel-circular-references/

http://www.dummies.com/how-to/content/dealing-with-circular-references-in-excel-2010-for.html

Troubleshoot circular references errors above is this tutorial from ofzen:

http://www.ofzenandcomputing.com/zanswers/4743/

http://www.ehow.com/how_2265255_check-circular-references-excel.html

http://www.ehow.com/how_8767009_rid-circular-references-excel.html

http://www.igetit.net/newsletters/Y06_06/circref.aspx

http://www.techrepublic.com/article/get-excel-to-calculate-formulas-with-circular-references/6130292

Good habit:

http://office.microsoft.com/en-us/excel-help/remove-or-allow-a-circular-reference-HP010342831.aspx

http://excel.tips.net/T002163_Dealing_with_Circular_References.html

http://www.exceltip.com/st/Circular_References_in_Excel_2007/1353.html

**Very good tutorials from jkp:**

http://www.jkp-ads.com/Articles/circularreferences02.asp

http://www.jkp-ads.com/Articles/circularreferences03.asp

http://www.jkp-ads.com/Articles/circularreferences04.asp