I am trying to write a formula whereby if a number falls into a range, then I populate the cell with a text label.
For example, if a number equals zero then the cell populates with the text 0. If the number is between 0-50, then the cell populates with the text 0-50. If the number is greater than 50 but less than or equal to 100, then the cell populates with the text 50-100....and so on. I have approximately 20 number ranges.
No laughing but I started writing something like the following and not only am I writing it incorrectly, it seems like a very long way about it. I'm sure there's a much more elegant way to think about this. I'd be grateful for any help.
=IF(J150216=0,"0",IF(J150216>0<=50,"Less Than 50",IF(J150216>50<=100,"50-100",IF(J150216>100<=150,"100-150",IF(J150216>150<=200,"150-200",IF(J150216>200<=250,"200-250",IF(J150216>250<=300,"250-300",IF(J150216>300,"Greater Than 300"))))))))
Bookmarks