Hiding error message

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.
 
B

Biff

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
 
M

Mark Flynn

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

Biff

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

unions, intersections or array constants 23
Conditional format entire row from one cell 2
Mapping integers to strings 5
how to remove #DIV/0! 7
Options for DIV#/0 6
If A1 is zero, A2 is blank 3
Calculation / Format Error 1
Custom number code [conditional] help 13

Top