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