FIND a character

B

Brian H

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.
 
B

Bernard Liengme

Try ISERROR(FIND("m",F3)) as your condition
=IF(ISERROR(FIND("m",F3)) ,0,B3)
I assume the B3 is correct and not a typo for F3
 
Top