Circular references introduction

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

http://blogs.office.com/b/microsoft-excel/archive/2012/02/17/circular-references-excel-error-message.aspx

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

Advertisements