Newbie Excel question

  • Thread starter Thread starter djarcadian
  • Start date Start date
D

djarcadian

I need an Excel spreadsheet to track my running balance. I have it al
laid out in Excel and it looks like this.


Code
-------------------

CHX # DEBITS DEPOSITS RUNNING BALANCE
OPENING BALANCE 2,557.93 $2,557.93
Norms Stump Removal 8514 -$175.00 $2,382.93
Angela Paycheck 8535 -$191.49 $2,191.44
David Bayard Paycheck 8536 -$326.17 $1,865.27
David Bayard Paycheck 8541 -$365.00 $1,500.27
City of Oakland 8503 -$45.00 $1,455.27
Norms Stump Removal 8561 -$350.00 $1,105.27
Norms Stump Removal 8565 -$170.00 $935.27
David Bayard Paycheck 8569 -$329.43 $605.84
MCI 8575 -$50.38 $555.46
PG&E 8576 -$45.47 $509.99
Department of Transportation 8577 -$10.00 $499.99
Hulx Hauling 8579 -$750.00 -$250.01
Kerry Bliss Paycheck 8584 -$1,274.06 -$1,524.07
Navor Molina Paycheck 8586 -$413.65 -$1,937.72
Waldemar Paycheck 8587 -$233.88 -$2,171.60
 
Put:
OPENING BALANCE in A1
2,557.93 in B1 (not really needed, could leave blank)
and $2,557.93 in C1
Put
Norms Stump Removal 8514 in A2
-175.00 in B2 (format the cells B1:B999 as currency if you want the $
sign)
in C2 enter =C1+B2 (result should be $2,382.93
copy this formula down to C999 - we will fix it later
Continue typing text in A cell and ingoing/outgoing amounts in B cell, C
cells will compute

Now to fix: change formula in C2 to =IF(isnumeric(B2),C1+B2,"") and copy
down to C999


Now get a book like EXCEL FOR DUMMIES and learn how to do more!

best wishes
 
Back
Top