#DIV/0! all over a worksheet doesn’t look pretty. Here is a simple If statement that takes care of it.
1. Let’s assume we want B1/A1
2. In C1 put this formula =IF(A1=0,”Uh- oh”,B1/A1)
3. Now if A1 = 0 while attempting B1/A1 then your cell will say Uh-oh instead of #DIV/0!
Sidenote: To make the result blank, remove uh-oh but leave the “”