Finding the right Microsoft Excel formula
November 9, 2006 11:01 AM Subscribe
I've got an Excel spreadsheet with numbers ranging from 2,000 to 600,000. I want Excel to look at each cell and essentially categorize all of those into five categories in a new column. If the value is less than 10,000, I want Excel to give it a 1, if the value is between 10,000 and 50,000 I want it to be 2, if the value is between 50,000 and 100,000, I want it to return 3, if it's between 100,000 and 500,000, I want a 4, and if it's above 500,000, I want a 5.
I tried the IF function, but I can't figure out how to a) make it recognize multiple variables, and b) I don't know how to tell it to look for numbers within a range. The Excel help section about arrays and lookups is fairly mystifying. Anyone got an idea?
(I know I could sort the data and do this manually, but I'd like to learn how to do this Excel's way.) Thank you!
posted by stonefruit to computers & internet (14 answers total) 1 user marked this as a favorite