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
|