Zero Division
On Mar 11, 5:18*pm, Beep Beep
wrote:
Can't remember the formula for not showing DIV/? error message when dividing
by zero
Hi,
You can have the catch all solution of
=if(iserror(your formula),"",your formula)
but this hides lots of errors so depending on your formula a better
solution may be to check for zero
=IF(A1=0,"",B1/A1)
which doesn't hide other errors
Mike
|