MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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??