Thread: how do I insert a cell based on its match with an adjacent cell?
View Single Post
  #12   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)

@Peo Sjoblom
I'm not sure what you mean... The cell result I wish to avoid is the #N/A.

If E11 has the result value #N/A, and I enter the formula:
=IF(E11="","",E11) in cell E12

All I (still) get is #N/A

Is there a way to avoid the #N/A result?
Reply With QuoteReply With Quote