Excel Spreadsheet--circular reference

[tareco]

Is there anyone out there who can help me fix a "circular reference" i
my spreadsheet? I cannot figure out how to do this and the "help" i
useless.

Please someone, provide step by step, detailed instructions. I'm eve
willing to email the spreadsheet to someone if you can help!

Thanks

 

[Frank Kabel]

Hi
you may post your formula in plain text which causes the circular
reference. Also add your desired result / explain what you're trying to
achieve.
to give you an example:
if you enter the following formula in A1:
=SUM(A1:A10)
you will get the circula reference error, as the formula tries to
included its own result in the SUM function. In this case the formula
may be changed to
=SUM(A2:A10)
to prevent the error

 

[Bernard V Liengme]

Suppose in A10 you enter =SUM(A1:A10). This is a circular reference - the
formula in A10 refers to the cell A10.
If I Cut/Paste the formula to a cell such as B1 it will work.
What formula is giving you the error message? And what cell is it in?
Bernard

 

[tareco]

Thanks for the response! Let me explain the predicament I'm in.

This spreadsheet was sent to me from somone else who did it. Tha
person is unreachable for a few days and I need to use this spreadshee
before then!

Upon opening it, I received the error regarding the circular reference
I then noticed that a lot of the numbers weren't adding up o
calculating properly and I desperately need to fix it!




HELP!!!

 

[tareco]

I know absolutely nothing about making a spreadsheet. I don't know
anything about formulas or what the formula is for this particular
spreadsheet. What a learning experience! Am I totally screwed or
what?

 

[Frank Kabel]

o.k. mail me your sheet
frank[dot]kabel[at]frenet[dot]de

but no guarantee ;-)

 

[tareco]

Thanks so much! I've just sent it via email. I hope I got the addres
right---it's on it's way

 

[Frank Kabel]

Hi
Spreadsheet is on its way. Was just a simple circular reference:
A18=A18

Frank

 

[Ken Wright]

Just so you are aware, not all circular references are unintentional. Some
firms have an overhead that they apply to their Sell price for a service/widget
that is actually a % of the Sell Price itself. In this case you have to enable
iterations in the Tools / Options / Calculation dialog box, and Excel will
effectively back into the 'correct' number to within a ceretain tolerance. You
have to be very sure you know what you are doing before you do this though, as
it will also prevent any circular reference messages from unintended circs.