Thread: Zero Division
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Mike H[_3_] Mike H[_3_] is offline
external usenet poster
 
Posts: 39
Default 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