Trying to do an IF Statement for 3 different things

Hello there, I am trying to create 3 different IF statements.

Here is what I am trying to accomplish:

If cell J5 is Less than 2.33330 mark it as "L"
If cell J5 is between 2.33331 and 3.66659 than mark it as "M"
If Cell J5 is greater than 3.6666 than mark it as "H"

Here are the individual functions I've gotten to work, it's just when I combine them it doesn't:

=IF(J5<=2.3333,"L")
=IF(AND(J5>2.3334,J5<3.66659),"M")
=IF(J5>=3.6666,"H")

And here is the 1 I put it altogether with:

=IF(J5<=2.3333,"L"),IF(AND(J5>2.3334,J5<3.66659),"M"),IF(J5>=3.6666,"H")

If someone has some suggestions or an easier way to accomplish this, that would be great!

You can do it like this:

=IF(J5<=2.3333,"L",IF(J5<=3.66659,"M","H"))

Hope this helps.

Pete

You are amazing! Thank you so much.

You're welcome.

If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Also, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete