Excel Formulas

Hi

I have a simple project for any programmer familiar with Excel spreadsheet formuls.

I need a bank ledger made that will automatically keep tally of balance debits and credits.

I want it in this format

Col 1 Col 2 Col 3 Col 4 Col 5
Date Debit/Check – Debit +Credit Balance

WHere any amount entered into column 3 will be subtracted from Column 5
Where any amount entered into column 4 will be added to Column 5

I need it to work just like you are using a check register.

Leave a Reply

Your email address will not be published. Required fields are marked *