Single Digit Number

[Bartlett_1982]

Evening.

I have searched the forum but could not find the answer.

How do I prevent a formula when searching for a 1 picking up say 12 for example?

 

[mikerickson]

What formula are you talking about?

 

[Bartlett_1982]

what formula are you talking about?

=iferror(if(find(1,$i2,1),1,0),0)

 

[mikerickson]

What do you want that formula to return?

It will return 1 from any string that contanins the numeral "1", like "ab1xz" and "ab123"

What do you want it to return?

 

[Bartlett_1982]

If it is a 1 on its own, not contained in any other string.

 

[shg]

How about

=--(I2=1)

 

[mikerickson]

or =--EXACT($I2, "1")