Can you post your formula ? You'd probably receive better, more specific
responses that you could then apply direct into your sheet.

Anyway, one usual way to error-trap #N/A errors
is to use something like:

=IF(ISNA(<formula),"---",<formula)

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"jolly79_ph" wrote
in message ...

Hi, I need help, i just wanted a formula to assign "#N/A N.A." into
"----", which is blank. thanks in advance. :)


--
jolly79_ph
------------------------------------------------------------------------
jolly79_ph's Profile:
http://www.excelforum.com/member.php...fo&userid=4835
View this thread: http://www.excelforum.com/showthread...hreadid=499652