Hide text in cell

  • Thread starter Thread starter Naas
  • Start date Start date
N

Naas

got the following text in cells that I want to hide;

FALSE , #div/0!

How do I do it?

Thanks
 
Hi
you may post your formulas which you're currently using. Best way to
add some error checking to them
 
If FALSE is being generated by an if statement for which you haven't
provided a False option:

=IF(<criterion>, true option)

Then use

=IF(<criterion>, true option, "")


For #DIV/0, check the denominator first:

=IF(B1=0,"",A1/B1)
 

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

Back
Top