multiple conditions for IF statement in a table, can Excel handle this kind of processing?

[Neo4u]

Hello All,

I am having another problem, I have the following situation.. I want to assign a value from a Table where the specific condition is given in the table itself.

the problem here is i got multiple conditions before he can assign the right value and the problem is the list is for about 200 entries i want to assign a score to. And i want to use about 37 criteria's like so to do this manually it will take a tremendous time and this must be anti-excel way of working!!
0<x< 10 then assign A
10<x<20 then assign B
etc etc..
Thank you.

 

[jimrward]

if you align thoughts with excel columns you could use the following as it will assume A1, which is not needed for anything but creating the final letter, and will work for anything above 260

=MID(ADDRESS(1,INT(A1/10)+1),2,SEARCH("$",ADDRESS(1,INT(A1/10)+1),2)-2)

 

[Aladin Akyurek]

if you align thoughts with excel columns you could use the following as it will assume A1, which is not needed for anything but creating the final letter, and will work for anything above 260

=MID(ADDRESS(1,INT(A1/10)+1),2,SEARCH("$",ADDRESS(1,INT(A1/10)+1),2)-2)

See for more important reason, post #10.

 

[jimrward]

given the original request, my solution fits the purpose