What formula do I need to calculate a level based on a %?

[sheebee22]

Hi all,

I am really struggling to work out the formula I need, please help!

I have an assessment sheet in Appsheet where people input different scores for people. Then Appsheet calculates the overall percentage. What I now need is a formula which works out what the overall level is, based on the % score

(0-21%= Level 0

22-54%= Level 1

55-85%= Level 2

 86% and above= Level 3.)

But I just cannot work out which formula to use. I basically want it to look at the row above where the % score is, and then calculate the level based on the above criteria. I tried using IFS AND but I couldn't work out how to get this working. 

Your help is hugely appreciated! Thanks!