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 “”
What if i have a a function in one of my cells that pulls data from another sheet, but isn’t populated yet? for example currently i have:
=+’Raw email data’!BZ26 in cell BV6, but the data in the sheet being rad isnt populated yet (next month it will be) and my current sheet shows the #DIV/0! code.