| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
hide the #N/A error
if(iserror(your_formula), "", your_formula)
"Peo Sjoblom" wrote: =IF(ISNA(your_formula),"",your_formula) -- Regards, Peo Sjoblom "SheriTingle" wrote in message ... Hi and thanks for the help. I have some calculations that show the #N/A error because the value to correct the error will be added in the future. For now I do not want the #N/A error visible. I know how to use conditional formatting to make it disappear and I know how to use the =if(iserror()) method. BUT someone showed me a formula that nested some type of NA function that took care of the problem quite easily. I just can't remember what it is. Any ideas? This is for version 2003. : ) THANKS |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide Error Message | Excel Discussion (Misc queries) | |||
| How do I use ISERROR in functions to hide error values | Excel Worksheet Functions | |||
| Hide #div/0 Error When Averaging | Excel Worksheet Functions | |||
| Hide empty field error | Excel Worksheet Functions | |||
| Getting Excel error when trying to hide columns. Why? | Excel Discussion (Misc queries) | |||
Hybrid Mode
