=IF(ISNUMBER(FIND("m",F3)),0,B3)
Regards,
Peo Sjoblom
"Brian H" wrote:
Hello All,
I want to find a character in an entry in Excel and assign a value in
another entry depending on if the character is found or not. For example, I
am trying to use
IF(FIND("m",F3)=#VALUE!,0,B3)
to give me a value 0 if the logical test in the IF function is TRUE.
Otherwise, return the value in B3. The problem is if "m" is not found, FIND
returns the #VALUE! error value, and I have no idea on how to test for this
condition. Any ideas? Does anyone have another suggestion on how to
accomplish what I am trying to do? Thank you.
|