This is a basic example but I've used this method for years regardless of how complex the formulas. Let's say you will have D2 perform a division based on values in B2 and C2. Instead of a straight-forward formula in D2 like this:
=B2/C2 (which initially causes D2 to show the #DIV/0!)
I wrap an IF condition around D2's formula pointing to C2 (the last cell needing a value in order to perform the calculation) like this:
So when I plug the first value in B2, then the second value in C2, once C2 is no longer blank, D2 lights up with the result of the calculation. So you can use this method whether to hide zeros, negatives or the #DIV/0!. Just adjust the formula as needed.
Keep Up with TechRepublic