#n/a

[alen_re]

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

[Niek Otten]

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

--
Kind regards,

Niek Otten

"alen_re" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Bob Phillips]

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"alen_re" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>