Account Ledger formula

[petiteshiraz]

I need help with creating formulas to work in my spreadsheet. This is what I want to do:

I have four boxes lined up horizontally - they are "Debit", "Credit", "Balance Debit" and "Balance Credit".

If there is a figure in teh "Debit" box, I want that number to be deducted from the figure currently in the "Balance Debit" or "Balance Credit" just above. It's an accounting ledger so the balance will either be in the "Balance Debit" or "Balance Credit" but not both.

Does this make sense?

 

[Yard]

Assuming the data goes from column A to column D, do you mean this:

=IF(A3>0,C2-A3,C2+A3)

??

This will add the value in Debit to Balance Debit if the value is >0, and subtract it from Balance Credit if the value is <0.

Adjust the +/- signs to suit.

 

[petiteshiraz]

That's not working...

This is how it should work:



Column A----------Column B----------Column C----------Column D
Debit---=----------Credit------------Balance Debit------Balance Credit
-------------------$5,000-------------------------------$5,000
$1,000--------------------------------------------------$4,000
$6,000------------------------------$2,000

 

[Yard]

Sorry, I'm not really familiar with Account Ledgers. Are you showing us what you have, or what you want?

 

[petiteshiraz]

I'm showing what I want.

I wish I could copy/paste here but I don't see an option to.

 

[Yard]

Sorry, I don't understand what you have and what you want.