1. ## Simple bank check spreadsheet help

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. .
Code:
`=If(E1="","",(E1+(D2-C2)))`

3. 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. 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.  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. .
Paste in E3 and copy down :

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

7. 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. .
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. 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. .
Excel 2007.

Strange though ... it is a very basic formula. Wouldn't think there would be that much difference 97 vs 07 ..

Page 1 of 2 1 2 Last

#### Posting Permissions

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