Trouble with Nested IF Excel Formula

[Dad_x6]

Hello. I am trying to do a Nested IF (or maybe SWITCH???) for a cell in Excel. My cell that I am looking at could have 3 values (11+ Years; 5-10 years; < 5 years). One of the troubles is that they could put more than those values in the cell (such as "We have been in business for 11+ Years"). The values that I would like to assign are 5, 3, and 1. Here is what I tried...

=IF(Find("11",C60,1)>0,5,IF(Find("10",C60,1)>0,3,1))

No luck.

Thoughts?

 

[Fluff]

How about

=IF(ISNUMBER(FIND("11",C60,1)),5,IF(ISNUMBER(FIND("10",C60,1)),3,1))

 

[Dad_x6]

Beautiful! Thank you!

 

[Fluff]

You're welcome & thanks for the feedback.