Hide the #DIV/0! Error
Note that this will cause any other errors to be masked as well.
There's no real reason to get the reference to A1 and to do the division
calculation either, the #DIV/0 error only appears if B1=0, so
=IF(B1=0,"",A1/B1)
works more efficiently.
In article ,
Gary''s Student wrote:
IF(ISERROR(A1/B1),"",A1/B1)
--
Gary''s Student - gsnu200765
"RyanH" wrote:
Is there a way to not show the #DIV/0! Error in a cell? I would like to
have
the cell blank instead.
Thanks in advance.
|