Perhaps if it is only an error you are interested in try

iserror(a4)

eg if(iserror(a4),b3,a4+3)

This also traps some other errors, but that should not be a problem to
you I imagine

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=551881