Using if statement, for a number between two values.

[mon_751]

I crated random numbers between 0 and 100, and I want to convert those numbers to have a specific value from 1-6 depending on the random number value. Those specific values are the following:
0-30 should output a 1
30-40 should output a 2
40-60 should output a 3
60-70 should output a 4
70-75 should output a 5
75-100 should output a 6.
I taught about using the IF statement like this.. (If(A1=0,1,IF(A1=1,1,IF(A1=2,1...) but it will be a very long function.

 

[Joe4]

One way:

=IF(A1>75,6,IF(A1>70,5,IF(A1>60,4,IF(A1>40,3,IF(A1>30,2,1)))))

 

[Jonmo1]

Try

=MATCH(A1,{0,31,41,61,71,76})


Though your ranges overlap each other, ie should 30 be 1 or 2 ??