Results 1 to 2 of 2

Thread: Simple bank chech spreadsheet help

  1. #1
    Seeker Contax's Avatar
    Join Date
    Nov 2018
    Location
    Brigg
    Posts
    8
    Articles
    0
    Excel Version
    MS Office 97

    Simple bank chech spreadsheet help



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have a spreadsheet to keep check on bank account and need help with a formula. =sum(E1+D2-C2) This is in line 2, E1 is opening balance on line 1, it works but when I copy to rest of E column I get running balance in every unused row, is it possible to make empty rows show 0 or nothing until something entered in columns C or D. Helpfrom you younger brainy users appreciated.

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,272
    Articles
    0
    Excel Version
    Office 365 Subscription
    Duplicate thread closed - one thread per issue only, please.
    Ali
    Enthusiastic self-taught user of MS Excel!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •