[Solved] Determine balance after deposits and payments

[Bigmack1866]

I have a check register/ Budget spreadsheet that I have used for years and I am trying to update it and fix some issues that it has. It has 4 cells. Discription, Deposits, Debits, and Balance. The if statement I use is =IF(C3="";IF(D3="";"";E2-D3);E2+C3). As long as I only enter a value in only 1 column it works ok. If I enter a value in both D3 before C3 it works. If I change D3 then nothing changes. If I then change C3 it calculates E2 + C3 and ignores D3. I know why, it has to do with the way it is written, however I have never figured out how to make it work properly. Only one cell should be populated at a time. How can I make it so if C3 has a value D3 is nil or 0 and if D3 has a value C3 is 0, or how do I force the original fomula to recalculate if either value changes not just C3? Have I confused you, II have myself.

oo doc.PNG (61.16 KiB) Viewed 1764 times

Edit: Changed subject, was Formula Problem/i]  Make your post understandable by others  -- MrProgrammer, forum moderator

[FJCC]

I don't understand why you can't use the following formula in E3

Code: Select all

=E2 + C3 - D3

Blank cells are treated as 0.
If you want the cells in column E to look empty if there are no values in C or D, try

Code: Select all

=IF(AND(ISBLANK(C3);ISBLANK(D3)); ""; E2  + C3 - D3)