Avoid Excel Division by Zero Errors

divbyzero.png When your Excel formula results turn out to be that ugly divide by zero error #DIV/0!, customise the way they are displayed using the IF function. The Producitivity 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). If you're an Excel nerd who loves in-cell logical tests as much as I do, you'll also like conditional cell formatting.


Be the first to comment on this story!

Trending Stories Right Now