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

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

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

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

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

--
Biff
Microsoft Excel MVP


"Harshad" wrote in message
...
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

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

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

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

On Tue, 16 Sep 2008 22:29:00 -0700, Harshad
wrote:

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