Excel 2010 - Creating a formula for a range of cells some of which are blank

[piquet41]

Hi Everyone. This my first post (other than the welcome post).

I am trying to basically reproduce my bank statements in excel. What I would like help with is a formula to do this. I have a data range of 4 columns and 290 rows (including "blank" cells). I.E. Date, Money in, Money out, Balance.

There will only be data in those cells in which money has been either deposited or withdrawn, and to the right of those columns the balance.

All examples of formulas in my book contain data in ALL cells. Hopefully this is possible, and hope someone can help me

VMT piquet41

[dilipandey]

Hi piquet41,

There will only be data in those cells in which money has been either deposited or withdrawn, and to the right of those columns the balance

This is how the bank statements used to be.. either Deposite or withdrawn and then the total balance at last... I am not sure how you want that statement to appear.. ?

Regards,
DILIPandey

<click on below 'star' if this helps>

[piquet41]

Hi Dilipandey, all i want to do is to put this information into an excel spreadsheet and for it to calculate the balance. Otherwise i am going to have to manually input all entries, in which case i can just use word. I was hoping that a formula was available for me to do this.

I.E. a1-date, a2-money in, a3-blank, a4-balance
b1-blank, b2-blank, b3-money out, b4-balance etc..... going down eventually to about 290 rows over a year.

I have created multiple worksheets for different years. Hope I,ve made it clear lol! I'm not as good as lots of people on here.
VMT
piquet41

[royUK]

You don't want any empty rows

In D3 =D2+B3-C3

Assumes opening balance in D2

[piquet41]

You don't want any empty rows

In D3 =D2+B3-C3

Assumes opening balance in D2

Hi RoyUK, Thats ok for for one entry. What about my next entry, say I have made a deposit and nothing else what formula would reflect my balance? (no money out so cell blank) I only want data in those cells which need it. I thought you could have your formulas include "blank cells" ?

[royUK]

As I said, no empty rows in the table.

[piquet41]

OK thank you RoyUK. I guess I'll just create a word table and type every entry manually. Can't believe excel can't handle blank cells. Nevermind.

[JosephP]

what's the problem? just copy roy's formula down as you add new rows of data-it won't care if a cell is blank, it will treat it as 0.

[piquet41]

Sorry RoyUK. Talk about creating a mountain out of a mole hill. Thank you for your formula..... it works absolutely fine. Please excuse me for being thick. I didn't read your post correctly. Have a great day, and once again thank you for your help and assistance.