#VALUE! & find()

B

bc4n

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.

thanks.
 
V

venkat

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


==================================
 
D

David Biddulph

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
==================================
Click to expand...

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")
 
B

bc4n

thank you for your answer, actually the cell is contain error value and a
value, so if I use =IF(ERROR.TYPE(A1)=3,"Error type is Value","False") the
return value if the cell contain a value isn't "False" but #N/A! so I can't
use this.

But if we use =IF(ISERROR(A1),"no","yes") the return value if the cell
contain ada value is "yes"

Thank you for both of the answer, It's help my work.
 
Top