Zero Division
 

Can't remember the formula for not showing DIV/? error message when dividing
by zero

Zero Division
 

Something along the lines of

=IF(B1<0, A1/B1,"")

or

=IF(ISERR(A1/B1),"",A1/B1)

--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)



"Beep Beep" wrote in message
...
Can't remember the formula for not showing DIV/? error message when
dividing
by zero

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