Arrow left
Back to product 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 ­čĹç

Do you need personal help?

Our team of real people are here to help you any time between 9am and 10pm GMT.
Check Icon
Email us at:
Check Icon
Call us at +1 (415) 650-1711