View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Harshad[_2_] Harshad[_2_] is offline
external usenet poster
 
Posts: 44
Default I want to see blank cell rather to see #DIV/0!

Thank you very much for immediate reply.

After posting qustion, i find other posts, the same answer i got from one
post.
I immediatly applied to my formula and thank a lot, i got sucess.

Thank you again,
Harshad

"EricBB" wrote:

=IF(ISERROR(your formula),"",your formula)

"Harshad" wrote:

Hi all,

I have prepared some calculations, some where i saw the cell cointaining
"#DIV/0!".
i want that the cell cointain formula will see as blank, but not the
"#DIV/0!".
I can remove zero by toolsoptionview window option dont check on Zero
value.

Thank you.
Harshad