| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I hide the #N/A to not show in the cell
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I hide the #N/A to not show in the cell
=IF(ISNA(yourformula,"",yourformula)) your parens may differ
Example for VLOOKUP =IF(ISNA(VLOOKUP(G1,$A$1:$F$31,2,FALSE)),"",VLOOKU P(G1,$A$1:$F$31,2,FALSE)) Gord Dibben MS Excel MVP On Thu, 11 Dec 2008 16:27:01 -0800, Dylan @ UAFC wrote: |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide/Show Data | Excel Discussion (Misc queries) | |||
| How do you show/hide individual cell gridlines in Excel 2007? | Excel Discussion (Misc queries) | |||
| Hide Formula and Show Value | Excel Discussion (Misc queries) | |||
| Hide Formula and Show Value | Excel Discussion (Misc queries) | |||
| Hide column and show only in row in use | Excel Discussion (Misc queries) | |||
![Dylan @ UAFC[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
