Simple bank check spreadsheet help

C

Contax

New member
Joined
Nov 6, 2018
Messages
8
Reaction score
0
Points
0
Location
Brigg
Excel Version(s)
MS Office 97
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.
 
.
Code: 
=If(E1="","",[COLOR=#333333](E1+(D2-C2)))[/COLOR]
 
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.
 
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.
 
DateDescriptionReceivedPaidBalance
05/11/2018Opening Balance£1,000.00
06/11/2018DWP Received£100.00£1,100.00
07/11/2018Service Charge£200.00£900.00
07/11/2018Hairdresser£20.00£880.00
£880.00
£880.00
£880.00
£880.00

Thanks for support I hope I have done it right.
 
.
Paste in E3 and copy down :

=IF(A3="","",E2+C3-D3)
 
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
 
.
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 ?
 
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.
 
.
Excel 2007.

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

Attachments

  • Checkbook.xlsx
    10.2 KB · Views: 11
Last edited:
Contax
If you can't resolve the problem by comparing your worksheet with the one posted by Logit (#10), then the best solution would be to attach your workbook illustrating the problem/s for us to look at.
 
Hercules1946
Sorry not been back but been too ill. I am using Excel from Office 2007, thought it was Office 97 but I was wrong. copy of my spreadsheet below.

DateDescriptionReceivedPaidBalance
05/11/2018Opening Balance£1,000.00
06/11/2018Received Pension£200.00£1,200.00
07/11/2018Service Charge£40.00£1,160.00
07/11/2018Fuel£20.00£1,140.00
£1,140.00
£1,140.00
£1,140.00
£1,140.00
£1,140.00
£1,140.00
£1,140.00
£1,140.00
£1,140.00
£1,140.00
£1,140.00
£1,140.00
£1,140.00
£1,140.00
Cell E3 contains formula =SUM(E2-D3+C3) which I copied to all rows in column E, it works but I wanted balance in E to show 0.00 or be blank until I enter something in C or D column of next row, is this posible.
 
Contax
If you look at the attachment made by Logit in post #10, and compare the formulas in column E with yours above, you will see that yours omits the instruction to return "" if there is no date in col A. Add that to yours to
resolve your issue.

HTH
 
Hercules1946
I did it again and it changed font and size but never worked, I reset settings in format cells to same as it is in others and it worked, just what I wanted, now I won't have to use calculator for every line I add to my bank check, thanks also for explaining what the section before my formula does.
Many thanks to you and Logit for the help and sticking with me.
Merry Christmas to you all from Contax.
 
.
Glad you have it running. You are welcome.
 
You must log in or register to reply here.
Back
Top