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