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 “”
Can't get the tutorial to work for you? Need help with your code?
Get answers right away at our AE Excel Support Forums!
Get answers right away at our AE Excel Support Forums!
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.