Hiding error message

  • Thread starter Thread starter Mark Flynn
  • Start date Start date
M

Mark Flynn

I have a cell that displays an error message #DIV/0! (divide by zero error).
How do I hide this error message?
I tried Conditional Formatting: Formula Is =ISERROR (the cell that contains
the zero). But I get an error message that reads "You may not use unions,
intersections, or array constants for Conditional Formating criteria." The
cell that contains the zero is on an adjacent worksheet.
 
The cell that contains the zero is on an adjacent worksheet.

Change the formula to test for 0. Since you didn't post your formula try to
adapt this to it:

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

Biff
 
Hi Biff:
Thanks for your pormpt reply.
Yes, your IF function worked like a charm.
Best regards, Mark Flynn
 
You're welcome. Thanks for the feedback!

Biff

Mark Flynn said:
Hi Biff:
Thanks for your pormpt reply.
Yes, your IF function worked like a charm.
Best regards, Mark Flynn
Click to expand...
 

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

if(iserror()) question 2
Help needed 0
unions, intersections or array constants 23
remove error value when formula exists for empty cells 2
Formula 2
Mapping integers to strings 5
Adding recognised Zeros 5
Divide by the minimum non-zero number in a range of cells 21

Back
Top