I want to see blank cell rather to see #DIV/0!

[Harshad]

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 >tools>option>view> window option> dont check on Zero
value.

Thank you.
Harshad

 

[EricBB]

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

 

[T. Valko]

Post an example of your formula that returns #DIV/0!

 

[Harshad]

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

 

[Gord Dibben]

ISERROR will mask all errors, not just "#DIV/0!"

You may not be happy with that.

Suggest you post the formula for further review. There may another method.


Gord Dibben MS Excel MVP