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.

‍