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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: