IF statement for part of a number

Hello,

I was wondering if there is a way to write an IF statement that looks at only one of the 4 digit numbers on another column and return a value based on them?

For example:

on A1 through A5 I have the following numbers: 9521, 7803, 6649, 4107, 5764.

I want my IF Statement to look at the second number in each cell and return a specific value like this:
If the second number is 5 then return value "Music"
If the second number is 8 then return value "Movies"

OR

IF the second number value is between 1 and 3 then return value "Sports"
IF the second number value is between 4 and 6 then return value "Music"

Any help would be much appreciated.

Thank you

Do you mean 2nd DIGIT in each number?

Following the specific example, with the precise values (of 2nd digit), here's one way: cell B1 could have: if(mid(A1,2,1)="5","Music",if(mid(A1,2,1)="8",... followed by whatever other values you wanted based on that 2nd digit. You could also make a vertical lookup table, with each value, in numerical order, in once column, and, alongside, the "music", "sports" values etc that you want to match to the numbers, then you would type into, say, B1:
vlookup(mid(A1,2,1),2). In mid(A1,2,1), the 2 of this part of the formula is starting from the 2nd digit; the 1 after that means 1 digit only. In vlookup(mid(A1,2,1),2), the 1st column (the digits) are regarded as column 1, the digit is found, and - the 2 at the end of the formula - excel pulls up the matching value in the 2nd column of this table. Hope this makes some sense. Also check out vlookup for exact match, or between one value and another . . .

lotusman,

YOU THE MAN!!!!!!!

Thank you so much! It worked perfectly!