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
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