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.
|