to calculate interest without circulare refs:
- calculate cash balance before interest
- calculate interest on cash balance
- calculate cash balance + interest

Charles
_____________________
Decision Models
FastExcel 2.2 Beta now available
www.DecisionModels.com

"JeremyH1982" wrote in message
...
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