it is painful but you can use a shortened version of long formulas to test
for error
I am sure you are aware you can cut and paste in the formula bar,not so
painful then
--
paul
remove nospam for email addy!



" wrote:

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.