Newbie Excel question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

djarcadian - 29 Oct 2004 17:08 GMT

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

-------------------

Reply to this Message

Bernard Liengme - 29 Oct 2004 17:40 GMT

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

Signature

Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address

> I need an Excel spreadsheet to track my running balance. I have it all
> laid out in Excel and it looks like this.
[quoted text clipped - 21 lines]
>
> --------------------

Reply to this Message