View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ian
 
Posts: n/a
Default circular reference (Excel 2000)

Do you mean you need A8 to equal A1 (as your example suggests)? In A8 enter
=A1 to do this.
Do you mean you need a add A1 to whatever is already in A8? In A8 enter
=A1+A8 to do this. This will result in a circular reference. Go to
ToolsOptionsCalculation, select Iteration and change Maximum iterations to
1. The problem with this is that every time the sheet is recalculated, A1
will again be added to A8. There are ways round this using code, but there's
no point in going into this unless this is really what you need.


--
Ian
--
"peaspud" wrote in message
...
Hi, I need help.I'm sure there is a simple answer,but i can't seem to find
it??!! All i'm trying to do is this:
A1 A8
25 25
Simple? I need the total (A8) to add the input number (A1), even if i
change
the input number.But all i seem to get is a "circular reference"
comment.There must be a formula out there that can help me??