Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
shame
shame asked in Computers & InternetSoftware · 10 years ago

What is the formula for doing bank statement in excel sheet?

I just need continous debit and credit balances of bank statement in excel sheet?

3 Answers

Relevance
  • IXL@XL
    Lv 7
    10 years ago
    Favorite Answer

    Say credits are added into col B, debits entered into col C. In D2 enter

    =SUM(B$2:B2) - SUM(C$2:C2) copy down col to match data .

    This will give a running total as to the value of the account.

  • Anonymous
    4 years ago

    Bank Statement In Excel Format

    Source(s): https://shrinkurl.im/a9wBk
  • D M
    10 years ago

    Alternatively you can have someone who is an expert in the matter do it for you professionally. It may be that at reduced cost you could get a good option for what you need.

    Source(s): www.banknovelties.co.uk
Still have questions? Get your answers by asking now.