"venkat" wrote in message
...

"bc4n" wrote:

hello, what is the value of the cell if there's #VALUE!. I want to use
conditional if, if cell is #VALUE! then 0.

from the formula find("d",A2) i get some value and #VALUE!, if there's
"d"
so the value is the number position of the "d", if there's "d" so the
value
is #VALUE!. If the cell contains #VALUE!, the next formula is also
#VALUE! so
if there's value of #VALUE!, I can change the #VALUE! into 0.


teh value of such a cell is ERROR.
supose that cell is A1. in b1 type
=IF(ISERROR(A1),"no","yes")
and see what happens
==================================

You can be more specific with the Error Type, to distinguish #VALUE from
other errors such as #DIV/0 or #N/A.

=IF(ERROR.TYPE(A1)=3,"Error type is Value","False")
--
David Biddulph