Thread
:
Hide the #DIV/0! Error
View Single Post
#
3
Posted to microsoft.public.excel.programming
JE McGimpsey
external usenet poster
Posts: 4,624
Hide the #DIV/0! Error
One way:
Instead of
=A1/B1
use
=IF(B1=0,"",A1/B1)
In article ,
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
JE McGimpsey
View Public Profile
Find all posts by JE McGimpsey