Hiding error message
 

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.

Hiding error message
 

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

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

Hiding error message
 

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


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

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

Hiding error message
 

You're welcome. Thanks for the feedback!

Biff

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


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

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