Forum Discussion
Show Blank or Zero
I went at it a slightly different way. Here's the formula as I wrote it:
=IF(AND(F69="",G69=""),"",H68-F69+G69)
You can copy this formula down many rows. It basically is saying, if there's no entry in column F or G, then stay blank. If there's an entry in either (or both), then take the running balance from the row above and subtract the debit amount (if any) and add the credit amount (if any).
Twifoo I am really glad to receive answer of my query of excel expense sheet. Thank you very much dear for helping me out. Ayub Khan
Thanks for your reply and it works very well to get a running total by copying your formula into the next line each time you enter new data; however, I wanted to copy and embed the formula to be ready each time I entered new data. Your suggestion produces the last number with new data all the way to the bottom. FYI I got this formula from another user which does what I needed. =IF(AND(F8="",G8=""),"",H7-F8+G8) F and G are the new numbers to be added or subtracted and H is the running balance. This allows me to copy the formula all the way down column H and will only produce a number in H when I have entered a new number in either F or G. Ayub-Khan
