Thread
:
Hide the #DIV/0! Error
View Single Post
#
2
Posted to microsoft.public.excel.programming
Gary''s Student
external usenet poster
Posts: 11,058
Hide the #DIV/0! Error
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.
Reply With Quote
Gary''s Student
View Public Profile
Find all posts by Gary''s Student