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! 

[alhazen]

How about this

IFS(
  AND(
    [overall total]>=0,
    [overall total]<=0.21
),
"Level-0",
AND(
[overall total]>=0.22,
[overall total]<=0.54
),
"Level-1",
AND(
[overall total]>=0,55
[overall total]<=0.85
),
"Level-2",
[overall total]>=0.86,
"Level-3"
)

[sheebee22]

Thank you, but I am getting this error message:

[alhazen]

Sorry my bad, it should be like:

IFS(
  AND(
    [overall total]>=0,
    [overall total]<=0.21
),
"Level-0",
AND(
[overall total]>=0.22,
[overall total]<=0.54
),
"Level-1",
AND(
[overall total]>=0,55,
[overall total]<=0.85
),
"Level-2",
[overall total]>=0.86,
"Level-3"
)

[sheebee22]

Thank you but I am still getting an error message like this:

[alhazen · Accepted solution]

You wrote the wrong formula. Just copy the formula given above.

[sheebee22]

Thank you very much! This now works perfectly! Really appreciate your help!