Home |
Search |
Today's Posts |
#1
|
|||
|
|||
ISERROR
I entered the ISError in my spreadsheet in order to hide the error messages
in my cells. It works great. However, I needed to add more rows and I dragged the formula down into the cells in the new rows and I get a 0 in these cells. Could someone explain why this is happening, I don't have a 0 in the cells I entered the ISERROR into in the first place. Thanks very much for any help. Best regards Dee |
#2
|
|||
|
|||
Can you provide an example of the code which is displaying 0?
-- Regards, db "Dee" wrote: I entered the ISError in my spreadsheet in order to hide the error messages in my cells. It works great. However, I needed to add more rows and I dragged the formula down into the cells in the new rows and I get a 0 in these cells. Could someone explain why this is happening, I don't have a 0 in the cells I entered the ISERROR into in the first place. Thanks very much for any help. Best regards Dee |
#3
|
|||
|
|||
maybe it's an issue with formating??
if the cells with the iserror function are formated as number, it will show a 0, you will need to convert the Data format to text to show a blank "Dee" wrote: I entered the ISError in my spreadsheet in order to hide the error messages in my cells. It works great. However, I needed to add more rows and I dragged the formula down into the cells in the new rows and I get a 0 in these cells. Could someone explain why this is happening, I don't have a 0 in the cells I entered the ISERROR into in the first place. Thanks very much for any help. Best regards Dee |
#4
|
|||
|
|||
The code is =IF(ISERROR(C21*6),"",(C21*6)). The cells have to be in number
format. The initial cells with this function left the cell blank even with the format of the cells being number "General Format) I just added some rows and dragged the formula down. Acutally one cell showed no zero and then the cells following showed 0's Thanks again for your help. "db" wrote: Can you provide an example of the code which is displaying 0? -- Regards, db "Dee" wrote: I entered the ISError in my spreadsheet in order to hide the error messages in my cells. It works great. However, I needed to add more rows and I dragged the formula down into the cells in the new rows and I get a 0 in these cells. Could someone explain why this is happening, I don't have a 0 in the cells I entered the ISERROR into in the first place. Thanks very much for any help. Best regards Dee |
#5
|
|||
|
|||
If you insist on masking error values in the target cells instead of
eliminating their cause, try: =IF(ISNUMBER(C21),C21*6,"") instead. Dee wrote: The code is =IF(ISERROR(C21*6),"",(C21*6)). The cells have to be in number format. The initial cells with this function left the cell blank even with the format of the cells being number "General Format) I just added some rows and dragged the formula down. Acutally one cell showed no zero and then the cells following showed 0's Thanks again for your help. "db" wrote: Can you provide an example of the code which is displaying 0? -- Regards, db "Dee" wrote: I entered the ISError in my spreadsheet in order to hide the error messages in my cells. It works great. However, I needed to add more rows and I dragged the formula down into the cells in the new rows and I get a 0 in these cells. Could someone explain why this is happening, I don't have a 0 in the cells I entered the ISERROR into in the first place. Thanks very much for any help. Best regards Dee -- [1] The SumProduct function should implicitly coerce the truth values to their Excel numeric equivalents. [2] The lookup functions should have an optional argument for the return value, defaulting to #N/A in its absence. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ISERROR Conundrum | Excel Worksheet Functions | |||
iserror | Excel Worksheet Functions | |||
How do I throw in an ISERROR function on a complicated VVLOOKUP? | Excel Discussion (Misc queries) | |||
iserror | Excel Discussion (Misc queries) | |||
ISERROR Functin to Much Work! | Excel Worksheet Functions |