View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Dealing with errors

Does anyone know whether there is a neat way to deal with a formula
whose result may be "error" without using the "iserror" function and
effectively having to write the formula twice. For example, the
construct I use currently is =IF(ISERROR(my formula),"n/a",my formula).
This requires me to enter my formula twice which is redundant.