Show Blank or Zero

Creating bank balance sheet. On row "69" column F is check or debit amount while G is deposit and H is the result of either the subtraction of F69 from H68 or the addition of G69 to H68. I am using t...

excel

mathetes
Feb 26, 2020
I_B_C

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).

mathetes

Gold Contributor

Feb 26, 2020

I_B_C

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).

I_B_C

Copper Contributor

Feb 26, 2020

mathetes I can't believe that you were able to do that. I was totally unaware of that "and" function. Thank you so much. I_B_C

Forum Discussion

Show Blank or Zero

Resources