Just use the "*ISNA*" formula.
It returns TRUE if the value asked is #N/A. So in that case, just ask
if it is #N/A and replace the true response for whatever you want.
Hope it helps!
regards
Matías :)
--
mpiccione
------------------------------------------------------------------------
mpiccione's Profile:
http://www.excelforum.com/member.php...o&userid=24575
View this thread:
http://www.excelforum.com/showthread...hreadid=375130