Thread: how do I hide the #N/A to not show in the cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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 With QuoteReply With Quote