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

H

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
 
H

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
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

$DIV/0! 3
Delete the contents of a cell if it contains #DIV/0! Automaticall. 4
I need the cell to read 0 8
Div/0 2
DIV/0 1
Same formulas, but one returns a #DIV/0! error 7
How to change #DIV/0! result for an entire worksheet ? 4
Sandwich existing formulas with "If iserror(formula),0,formula)" 10

Top