
Select cell E2 because you'll want to inhibit all of the formulas in column E, not just the one that's currently displaying an error value.

Replace the simple equation with the following function: =IF(B2=0,"",D2/B2).

Using the Fill handle, copy the new function to cells E3:E6.
Full Bio
Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.