Nested IF statements on Excel

I’m trying to code the following on excel:

• if x is >=3 and <3.5, return "mild burnout"
• if x is >= 3.5, return "severe burnout"
• if x is <3, return "no burnout"

I have tried this:

=IF(AH2>=3,"mild burnout",IF(AH2>3.5,"severe burnout",IF(AH2<3,"no burnout")))

However, it does not return "severe burnout" values.

I believe thats because I can’t seem to enbed the "and" in this formula.

What i would like to achieve(without success) is:

=IF(AH2>=3 AND AH2<3.5,"mild burnout",IF(AH2>=3.5,"severe burnout",IF(AH2<3,"no burnout")))

This one does not work

>Solution :

Try:

=IF(AH2>=3.5,"severe burnout",IF(AH2>=3,"mild burnout",IF(AH2<3,"no burnout")))

This way you don’t need the extra complication of and()