circular reference formula
Posted by Sandi Brown on October 23, 2001 11:21 AM
I am trying to get several differnent cells to solve for one cell. My fomula looked like this.
=f25-f23-(f11:f13) I am trying to solve an unknow (cash) and need to take Total Assets - Fixed Assets - (the three elements known of Current Assest to solve for Cash). I have to show the forumula in the cell - I cannot just do the math .... Help
Posted by Mark W. on October 23, 2001 11:25 AM
What are the formulas in F25 and F23?
Posted by Sandi Brown on October 23, 2001 11:33 AM
f25 = =F14+F23
f23 = =SUM(F17:F22)
Thanks ....
Posted by Sandi Brown on October 23, 2001 11:46 AM
f25 = =F14+F23
f23 = =SUM(F17:F22)
Posted by Mark W. on October 23, 2001 12:18 PM
Sandi, I'm afraid that Accounting wasn't one of my
favorite subjects. If we're gonna figure this out
we need you to write your formula using accounting
terms (e.g., Cash = Total Assets - Fixed Assets...)
and then then identify the cell reference for each
of the formula's terms.
Posted by Qroozn on October 23, 2001 6:13 PM
what is the cell reference that is showing a circular link?
Posted by Richard S on October 23, 2001 10:50 PM
Sandi
I think you may need to use =F25-F23-sum(F11:F13). I assume F25 is total assets, F23 is Fixed Assets, and F11:F13 are non cash current assets. I am an accountant, but this still confused me a bit without seeing the data.
Hope that's what you wanted.
Richard
Posted by Richard S on October 23, 2001 10:53 PM
I also assume F14 is current assets (nt)
Posted by Sandi Brown on October 24, 2001 6:40 AM
I am attempting to input a formula into the balance sheet to calculate Cash for 1999. I am trying to use the ....
total assets (cell F25) which already contains a formula (F14 + F23) Total Fixed Assets + Total Current Assets
minus total fixed assets (cell F23) which already contains a formula (=SUM(F17:F22) ...sum of fixed assets
minus the sum of (F11:F13) (AR/Prepaid Insurance/Inventory)
to come up with Cash
The formula I used was
=F25-F23-sum(F11:F13)
I am getting a circular reference error, and don't know how to use circular references ....
Posted by Sandi Brown on October 24, 2001 6:44 AM
I'm not sure I understand your question. I'm sorry ... as you can tell, I am not stong in Excel skills.
I am attempting to input a formula into the balance sheet to calculate Cash for 1999. I am trying to use the .... the cell would be F10. When I input the forumla below into F10, I get the error. ...
I am trying to use the following cells to calculate cash
total assets (cell F25) which already contains a formula (F14 + F23) Total Fixed Assets + Total Current Assets
minus total fixed assets (cell F23) which already contains a formula (=SUM(F17:F22) ...sum of fixed assets
minus the sum of (F11:F13) (AR/Prepaid Insurance/Inventory)
to come up with Cash
The formula I used was
=F25-F23-sum(F11:F13)
I am getting a circular reference error, and don't know how to use circular references ....
Can you help me with this?
Posted by Juan Pablo on October 24, 2001 7:02 AM
Try
=F14-SUM(F11:F13)
Juan Pablo
Posted by Richard S on October 24, 2001 2:35 PM
also, what cell is the formula in??
