Hi
I need formula for ebalance:
TRIAL BALANCE ADJUSTMENTS BALANCE SHEET
ACCOUNTS DEBIT CREDIT DEBIT CREDIT DEBIT CREDIT
Petty cash 200.00 100
Cash on hand 0.00 3,433.54 12,334.00 A
Bank 2,560.00
St.Rundle Credit Union 1,650.45 0.00

If I have: +200-0+0-100= 100 automatically to go on debit column if result is negative automatically go to credit column of balance sheet.
(+3433.54-12344 = - 8910.46 to go directly on credit column of balance sheet)
Thank you.

Put this into a sample worksheet so I can see how you want this information to flow, including where you want the answers to go. Put in the answers manually and highlight those boxes, I'll see if I can convert your manual results into formulas.

If you need to show a couple of examples in your sample book, do so.