Morning everyone
I have a data set of numbers and I would like to write a formula which selects the range that the value falls into.
i.e. one of my numbers in the data set is 100. My range values are 0-50, 51-100, 101-150, etc, and 0-50 corresponds to "set 1", 51-100 to "set 2", 101-150 to "set 3".
I'd like my formula to return "set 2".
I can write a cumbersome IF formula but there is an easier way - can anyone please assist?
Thanks very much
Bookmarks