Check Book Calculation

R

Richard

If you have a Debit(-), Credit(+), and a Balance. How
would the formula be entered to calculate down a
spreadsheet in this order. For example: Column A would be
your Debit, Column B would be your Credit, Column C would
be your Balance. Just as if you were balancing your
checkbook.
 
N

Norman Harker

Hi Richard!

Try C2 formula:

=IF(COUNTA(A2:B2)<>1,"",C1+A2+B2)
Copy down to taste.

I have it defaulting to "" until an entry is made in A or B
 
E

Edie G

Assume your starting balance is in cell C1. Cell A2 has your firs
debit, cell B2 has your first credit.

The formula in cell C2 should be: =+C1+A2-B2

Copy this forumula into each cell in column C. The idea is you ar
starting with your beginning balance, adding each debit and subtractin
each credit, giving you your updated balance after each entry.

For a Credit Balance account (like an expense) you should reverse you
formula and subtract debits and add credits
 
Top