=IF(ISNA(YourFormula),"",YourFormula)

--
Kind regards,

Niek Otten

"alen_re" wrote in
message ...

This #n/a is giving me some troubles in my formulas..
is there anyway to hide this in the cell


--
alen_re
------------------------------------------------------------------------
alen_re's Profile:
http://www.excelforum.com/member.php...o&userid=28331
View this thread: http://www.excelforum.com/showthread...hreadid=504831