circular referencing?

Feb 26th, 2002, 08:30 AM

i have a figure in a cell, in the next cell to it i type a new number, i want the second cell to show the result of subtracting the first cell from the second cell, iwant the result to display in the second cell, iwant the reference to always be the previous cell whatever its address. i am a novice, be gentle with me.

Mark W. · Feb 26th, 2002, 08:39 AM

A formula cannot refer to itself. Therefore, you cannot enter =A2-A1 into A2 without getting a circular reference error.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 26th, 2002, 08:30 AM	#1
Guest Posts: n/a	i have a figure in a cell, in the next cell to it i type a new number, i want the second cell to show the result of subtracting the first cell from the second cell, iwant the result to display in the second cell, iwant the reference to always be the previous cell whatever its address. i am a novice, be gentle with me.

Feb 26th, 2002, 08:39 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	A formula cannot refer to itself. Therefore, you cannot enter =A2-A1 into A2 without getting a circular reference error.