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
Error message: "Word found unreadable content in FILENAME. Do you want to recover the contents of this document? 0
Dealing with the error: unable to filter on excel hc home school 0
MS Project - error message when checking "Critical tasks" 1
How do I make #DIV/0! error message go away? 2
Solved Disk Full error message when exporting PDF 0
Mapping integers to strings 6
Conditional format entire row from one cell 2

Top