# Help with Google Sheets formula

Hello Experts,

I'm sure this is a simple question, but I can't figure it out.  I have a spreadsheet in Google Sheets.  It basically keeps a running total of payments and deposits.  I got the formula working as needed, but when I copy the formula in the balance column, the column displays "FALSE" if there is nothing in the payment or deposit columns.  I would like the balance column to be blank if there is nothing in the payment or deposit columns.  I think the formula will have to have an "ISBLANK" IF statement, but I just can't seem to get this to work.  Below is the formula I have and an image of the issue.'

Thanks,
Nick

Formula:  =if(sum(F7:G7)>0,(-F7+G7)+H6,(if(sum(F7:G7)="0",0)))

LVL 1
###### Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Group Finance ManagerCommented:
Maybe this

=IF(SUM(F7:G7)>0,(-F7+G7)+H6,(IF(SUM(F7:G7)=0,"")))
Excel & VBA ExpertCommented:
Does this work for you?
``````=IF(SUM(F7:G7)=0,0,IF(SUM(F7:G7)>0,(-F7+G7)+ H6,0))
``````

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Author Commented:
This is what I ended up with after reading the above suggestions:  =if(sum(F20:G20)>0,(-F20+G20)+H19,(if(and(F20="",G20=""),"")))