Account balance

[gabriel]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I am creating an account balance spreadsheet similar to the ledger account balance sheet but without the compatibility issues with other versions of excel. I have two questions.

1. What is formula used to determine the balance
2. How do I make it so data is only computed for each new line and the formula doesn't need to dragged down

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I am creating an account balance spreadsheet similar to the ledger account
balance sheet but without the compatibility issues with other versions of
excel. I have two questions.

1. What is formula used to determine the balance
2. How do I make it so data is only computed for each new line and the formula
doesn't need to dragged down

1. Not a clue. It depends on what the items are, and how many are involved
in the balance calculation. Try entering an equal sign and then clicking on
the columns involved. This will insert a plus sign between fields,
undoubtedly some of them will have to be subtracted, so change the plus to a
minus where needed.
2. go to the Edit Preferences, and click Extend format and formulas