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