Avoid Excel Division by Zero Errors

When your Excel formula results turn out to be that ugly divide by zero error #DIV/0!, customize the way they are displayed using the IF function. The Productivity Portfolio blog explains how to test to see if your divisor is 0, and if so, display a blank value using something like

=IF(D2=0,''",C2/D2).