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

"vitality" wrote in
message ...

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