petiteshiraz
Board Regular
- Joined
- May 16, 2005
- Messages
- 145
I need to create a formula that categorizes the data from column A into one of 7 categories. For example, if cell A1 is 468, I need a formula to decide which of these categories it falls into:
1. 730 or more
2. 366 to 729
3. 180 to 365
4. 90 to 179
5. 60 to 89
6. 31 to 59
7. 30 or less
How can I do this?
1. 730 or more
2. 366 to 729
3. 180 to 365
4. 90 to 179
5. 60 to 89
6. 31 to 59
7. 30 or less
How can I do this?