Arrow left
Back to guides
Google Sheets Formulas

How to remove empty 0's from your Google Sheet

We may sometimes have rows in your financial report that contains 0's.

Those can be annoying. Here's a simple formula to replace them with two dashes (--).

  1. Instead of writing SUM(A1:B1)
  2. Write IF(SUM(A1+B1)=0,"--",A1+B1)

The formula simply checks if the sum of A1+B1 equals 0, and if it does, it prints "--". If it's not zero, it prints the actual value.


Learn how to do this step-by-step in the video below ­čĹç

Automate financial reporting with LiveFlow

Want to eliminate manual updates of your Excel & Google Sheets models?

Yes, show me how

Need help?

Our team is here to help you any time between 9am and 10pm EST.
Check Icon
Email us at:

Liked this article? Then you'll love the ones below

No items found.