Solved: evaluate some numbers

[CCkfm2000]

I’m trying to evaluate some numbers

So if any values between 1 to 25 equals = 1

between 26 to 75 = 2
between 76 to 100 = 3
between 101 to125 = 4
Etc.

and I’ve got this formula so far
=(INT(A1/25))*25/25

but it does not work, If I enter 24 I get 1 but if I enter 25 I get 2 should be 1

Help please

[VoG]

Try

=LOOKUP(A1,{0,26,76,101},{1,2,3,4})

[CCkfm2000]

thanks Vog

works like a treat

[Bob Phillips]

You can also use

=MATCH(A1,{0,26,76,101})

[CCkfm2000]

thanks xld.