Page 1 of 2 1 2 LastLast
Results 1 to 10 of 12

Thread: Simple bank check spreadsheet help

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

    Simple bank check 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
    Conjurer Logit's Avatar
    Join Date
    Nov 2016
    Posts
    202
    Articles
    0
    Excel Version
    2007
    .
    Code:
    =If(E1="","",(E1+(D2-C2)))

  3. #3
    Seeker Contax's Avatar
    Join Date
    Nov 2018
    Location
    Brigg
    Posts
    6
    Articles
    0
    Excel Version
    MS Office 97
    Logit thanks for your help, I put that code in E2 cell and copied it down cells in E column, result #VALUE! came up in cells. I wish computers and spread sheets were available when I was at school, don't know how lucky they are today.

  4. #4
    Acolyte alansidman's Avatar
    Join Date
    Oct 2018
    Location
    Steamboat Springs
    Posts
    39
    Articles
    0
    Excel Version
    2016
    perhaps if you uploaded a sample worksheet that is representative of your actual sheet and we can see the layout and formulas, then maybe we can solve this issue for you.

  5. #5
    Seeker Contax's Avatar
    Join Date
    Nov 2018
    Location
    Brigg
    Posts
    6
    Articles
    0
    Excel Version
    MS Office 97
    Date Description Received Paid Balance
    05/11/2018 Opening Balance 1,000.00
    06/11/2018 DWP Received 100.00 1,100.00
    07/11/2018 Service Charge 200.00 900.00
    07/11/2018 Hairdresser 20.00 880.00
    880.00
    880.00
    880.00
    880.00

    Thanks for support I hope I have done it right.

  6. #6
    Conjurer Logit's Avatar
    Join Date
    Nov 2016
    Posts
    202
    Articles
    0
    Excel Version
    2007
    .
    Paste in E3 and copy down :

    =IF(A3="","",E2+C3-D3)

  7. #7
    Seeker Contax's Avatar
    Join Date
    Nov 2018
    Location
    Brigg
    Posts
    6
    Articles
    0
    Excel Version
    MS Office 97
    Logit, did that and it put 1100 in E3 in a tiny font, came up with Data on the Clipboard not the same size and shape as the selected area, Do you want to paste the data anyway OK or CANCEL
    I erased my formula from cells first.

    Thank you.

    Contax

  8. #8
    Conjurer Logit's Avatar
    Join Date
    Nov 2016
    Posts
    202
    Articles
    0
    Excel Version
    2007
    .
    Not certain if you are asking a question or ....

    If the font size is an issue, why not highlight those columns (or the entire sheet) and format the font as desired ?

  9. #9
    Seeker Contax's Avatar
    Join Date
    Nov 2018
    Location
    Brigg
    Posts
    6
    Articles
    0
    Excel Version
    MS Office 97
    I was trying to say all it put in 1100 in E3 the other cells in colum E had nothing in even though the entries are still in the other cells in C & D, formula does not do anything in my Excel 97, is yours a newer version.

  10. #10
    Conjurer Logit's Avatar
    Join Date
    Nov 2016
    Posts
    202
    Articles
    0
    Excel Version
    2007
    .
    Excel 2007.

    Strange though ... it is a very basic formula. Wouldn't think there would be that much difference 97 vs 07 ..
    Attached Files Attached Files
    Last edited by Logit; 2018-11-09 at 02:28 AM.

Page 1 of 2 1 2 LastLast

Posting Permissions

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