i dont quite understand what "#N/A N.A." is but if you mean that you dont
want the error value #N/A to show but to have a blank intead then
=if(isna(your formula which may result in a #N/A error),"",your formula which
may result in a#N/A error))

--
paul
remove nospam for email addy!



"jolly79_ph" wrote:


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