S
spreadsheet monkey
I have a number of values ranging from positive to negative that I need to
sort into 5 categories depending on different ranges (i.e the number 3 and 5
are "1-10" and so on)
ex. of values:
1, 15, 0, -15, -32, -100
the positive are openended (i.e they range from 1 and up)
0 is included in the positive numbers.
the negative range from -1 to <-91. (i.e it ranges from -91 and down)
I need these to be sorted into categories and labeled in a separate column
like this:
range: label
-31<>-60 ; "'31-60"
-61<>-90 ; "'61-90"
<-91 "'>91"
I have tried to do this with VLOOKUP but I am unsure of how to do this with
open ends (i.e <-91 and >0)
there might be some way to do this with the IF function (or a combination of
other logical functions)
any ideas?
sort into 5 categories depending on different ranges (i.e the number 3 and 5
are "1-10" and so on)
ex. of values:
1, 15, 0, -15, -32, -100
the positive are openended (i.e they range from 1 and up)
0 is included in the positive numbers.
the negative range from -1 to <-91. (i.e it ranges from -91 and down)
I need these to be sorted into categories and labeled in a separate column
like this:
range: label
-1<>-30 ; "'1-30"0 ; "0"
-31<>-60 ; "'31-60"
-61<>-90 ; "'61-90"
<-91 "'>91"
I have tried to do this with VLOOKUP but I am unsure of how to do this with
open ends (i.e <-91 and >0)
there might be some way to do this with the IF function (or a combination of
other logical functions)
any ideas?