Zero Division

[Beep Beep]

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

 

[Chip Pearson]

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)

 

[Mike H]

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