Remove #DIV/0! errors

#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 “”

Leave a Comment