Formula to return Yes or No

[hammer2]

Hi folks

Cell B3 has "1,2,3,10" and I want "yes" in Cell N3 if Cell B3 has 10 as the final number and "no" if it does not.

Similarly if Cell B4 has 8,9,10,11 I want "yes" in Cell N4 if 11 is the final number and "no" if it is not.

So I would just adjust the formula to the final number required.

There are no triple digit numbers.

Cheers
Hammer

[hammer2]

Hi
Think I needed to supply more information.
Each final number (lets use 10) will have it's own sheet. But it will not always be the final number in the cells in that sheet.
I want to be able to return yes when 10 is the final number in the cells in col b

Likewise for all other numbers.

[benishiryo]

just a guess:
=IF(COUNTIF(B3,"*,10"),"yes","no")

or if 10 is in a cell say M3, then:
=IF(COUNTIF(B3,"*,"&M3),"yes","no")

if it's possible 10 stands alone in B3, then:
=IF(MID(","&B3,FIND("^",SUBSTITUTE(","&B3,",","^",LEN(","&B3)-LEN(SUBSTITUTE(","&B3,",",""))))+1,3)="10","yes","no")

[hammer2]

This "just a guess:
=IF(COUNTIF(B3,"*,10"),"yes","no")"

Exactly it, thank you.
I almost worked it out for myself but had too many * in the formula.

[Ghozi Alkatiri]

write at N3
=IF(ISNUMBER(FIND(ROW(10:10),B3)),"Yes","No")

copy down