Need help writing IF Statement

I need some help. I rarely use IF statements in excel, I usually do Index Matches, VLookups etc. So when I came across this, I thought I could come here for some help.

I want to have an IF statement that returns 5 values.

In the picture attached, you'll see 5 levels.

• If the value is less than or 0 then 5.
• If the value is 0.01 - 5.99 then 4.
• If the value is 6 - 12.99 then 3.
• If the value is 13 - 29.99 then 2.
• If the value is 30 or more then 1.

If anyone can help mem with this, that would be amazing!

Thank You!