In the example there is no circular reference, unless any of the G1:G5
formulas relies on A1.
In any case, there is a menu bar called "Formula Auditing", also on the menu
Tools-Formula Auditing, that can help you trace where the circular
references are.

Hope this helps,
Miguel.

"JeremyH1982" wrote:

Ok, Now I am not exactly sure of how to explain this, but here goes...

My boss is trying to create a formula in excel, to calculate interest or
something like that.

He keeps getting a circular reference. So his question is this...

Is there anyway to "Trick" a circular reference. such as for example

cell A1 =Round((B1*33%)/12)

and then in B1 have =G1-G2-G3-G4-G5

He is used to Lotus, and Since I have joined the company in June of last
year, I switched everyone over to Excel, but I'm not very familiar w/
circular references. I try and avoid them as much as possible. So any help
would greatly be appreciated.

Thanks
Jeremy