Google Sheets Formulas
How to remove empty 0's from your Google Sheet
SHARE THIS Article
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 (--).
Instead of writing SUM(A1:B1)
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.
Supercharge your financial reporting