Excel formula for calculating a balance

New Contributor

Hi. I am putting together a relatively simple spreadsheet to keep track of income and expenditure. 

I have a starting balance in cell H3.

I want to put a formula in cell H4.

If an Income value >0 is input into Cell E4 I want it to add to the H3 value and calculate the answer in H4. OR if an expenditure value >0 is input into F4, I want it to subtract F4 from H3 and calculate into H4. There will never be a value >0 in both E4 and F4. Any help would be gratefully received. Thanks.

2 Replies


In H4:




Fill down.

Thank you so much. I was trying to make things compicated. I am very grateful.