How can I get rid this value "#VALUE!" in the cell

[vitality]

hi all.

Due to the unknown cell value in some cell, I have some cell come up with "#VALUE!" in the side.

Is there any functions can delete the "#VALUE!" value?

I try the if statement, but fail。

thanks for your help

Vitality

[Anne Troy]

=if(iserror(formula),"",formula)
************
Anne Troy
www.OfficeArticles.com

"vitality" <[email protected]> wrote in
message news:[email protected]...
>
> hi all.
>
> Due to the unknown cell value in some cell, I have some cell come up
> with "#VALUE!" in the side.
>
> Is there any functions can delete the "#VALUE!" value?
>
> I try the if statement, but fail。
>
> thanks for your help
>
> Vitality
>
>
> --
> vitality
> ------------------------------------------------------------------------
> vitality's Profile:
> http://www.excelforum.com/member.php...o&userid=27267
> View this thread: http://www.excelforum.com/showthread...hreadid=468117
>