Output different numbers depending on the value between 2 numbers

[leakingpaint]

Good Day

I have been searching online for my question and found this particular site http://chandoo.org/wp/2010/06/24/between-formula-excel/ however I'm still a little confused. I'm currently using Excel 2007. Here is my question:

I need to display a level (number) depending on a percentage:

0-29% must display "1"
30-39% must display "2"
40-49% must display "3"
50-59% must display "4"
60-69% must display "5"
70-79% must display "6"
80-100% must display "7"

Any idea how one would do this?

Any help would be greatly appreciated

[JohnTopley]

Two column table D & E

0 1
30 2
40 3
50 4
60 5
70 6
80 7

=VLOOKUP(F2,$D$2:$E$8,2,1)

F2 is % value

[leakingpaint]

Thank you very much for the reply.

I am at work tomorrow and will try this. I will let you know if I come right, I appreciate the quick response and help!

Have a good day further

[Tony Valko]

Two column table D & E

0 1
30 2
40 3
50 4
60 5
70 6
80 7

=VLOOKUP(F2,$D$2:$E$8,2,1)

F2 is % value

Or...

=MATCH(F2,D2:D8)