| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Hiding or changing #N/A value
I have the following formula, =VLOOKUP($D$2,Table!$A$1:$B$26,2,False)*G2,
that returns #N/A in numerous cells. Obviously this is not professional looking and I would like to hide them or at least make them zero's and conditional format to hide them. I have tried the ISNA function which works on the #N/A but it returns FALSE when I use it on a cell that otherwise returns a value. I must have the same formula in every cell because my data changes monthly. Any guidance is much appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2000 crashes when changing fonts. | Excel Discussion (Misc queries) | |||
| Changing Dates in Excel | Excel Worksheet Functions | |||
| Changing font size in a list box | Excel Discussion (Misc queries) | |||
| Changing color in color palette | Setting up and Configuration of Excel | |||
| How can I change size of the picture without changing chartobject? | Charts and Charting in Excel | |||
Threaded Mode
