Thread: I want to see blank cell rather to see #DIV/0!
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
EricBB EricBB is offline
external usenet poster
  
Posts: 50
Default I want to see blank cell rather to see #DIV/0!
=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

Reply With QuoteReply With Quote