Is there a way to replace #DIV/0! with a zero? Thanks, Brett
B Brett Romero Jan 8, 2006 #2 A lttle additional information, the cell that produces division by zero should actually be blank because it didn't apply during this particular scenario. So I guess there needs to be a check to make sure the cell isn't blank. Brett
A lttle additional information, the cell that produces division by zero should actually be blank because it didn't apply during this particular scenario. So I guess there needs to be a check to make sure the cell isn't blank. Brett
D Dave Peterson Jan 8, 2006 #3 =if(a2=0,0,a1/a2) Maybe??? Brett said: Is there a way to replace #DIV/0! with a zero? Thanks, Brett Click to expand...
=if(a2=0,0,a1/a2) Maybe??? Brett said: Is there a way to replace #DIV/0! with a zero? Thanks, Brett Click to expand...
