| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hiding columns, error message says cannot shift objects off sheet | Excel Discussion (Misc queries) | |||
| Hiding a button when hiding rows | Excel Discussion (Misc queries) | |||
| Hiding zero values | Excel Worksheet Functions | |||
| Hiding rows before printing | Excel Discussion (Misc queries) | |||
| Hiding Personal.xls Requires Exit Twice | Excel Worksheet Functions | |||
Linear Mode
