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.