PDA

View Full Version : Solved: evaluate some numbers



CCkfm2000
06-15-2012, 05:51 AM
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
06-15-2012, 06:06 AM
Try

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

CCkfm2000
06-15-2012, 07:30 AM
thanks Vog

works like a treat :friends:

Bob Phillips
06-15-2012, 11:51 AM
You can also use

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

CCkfm2000
06-16-2012, 11:10 AM
thanks xld.