Thread: how do I insert a cell based on its match with an adjacent cell?
View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gabbon
 
Posts: n/a
Default how do I insert a cell based on its match with an adjacent cel
"Peo Sjoblom" wrote:

=IF(formula="","",formula)

Not quite:
if(formula="","",formula) only returns the #N/A value.

What you need is the additional use of the isna function, which will return
a usable value (TRUE, or FALSE) based on the presence, or otherwise of the
#N/A value.

The following will return a blank cell if the value in cell_ref is #N/A:

=IF(ISNA(cell_ref)=TRUE,"",(cell_ref))

Reply With QuoteReply With Quote