On 2002-01-14 16:20, Patrick wrote:
Can anyone tell me why this insists on bringing up the #DIV/0! Error
=IF((E6-F6)/E6="0","",(E6-F6)/E6)
Egads, I'm surprised no one nailed this down already.
Patrick, you probably already solved this, but in case you did not, here goes.
Look at your IF "condition":
(E6-F6)/E6="0"
The only times this condition will be TRUE is when E6 and F6 are EQUAL. Then your equation collapses to (0/E6); any time you devide zero by something you get zero.
A better test for your purposes is:
E6=0
because what you REALLY want to avoid with this IF equation is having to divide by zero, which is undefined and thus causes computers to have hissy fits.
So, your IF formula should read:
=IF(E6=0,"",(E6-F6)/E6)
which allows the results to be computed and displayed, and instead of getting DIV/0 errors, you get blanks whenever E6 happens to be 0.