IFS Formula based on cell multiple criteria

Hey there,

I've been trying to find a way to create a formula that allows me to categorize data based on various critera. I need to create a new column saying that if the cell is higher than the first value but smaller than the second, then it would be in category 1, and so on.. I have 4 different categories, but I just can't find a way to make it work.

Any thoughts?

If is between then
cell >0.4 <0.5 Cat 1
cell >0.5 <0.6 Cat 2
cell >0.6 <0.7 Cat 3
cell >0.7 <0.8 Cat 4

Untested, but try:

Formula:

Please Login or Register  to view this content.

You're welcome.