Condition for FAIL, APPROVE and EXCELLENT

[wsaico]

I think I am complicating myself with something simple, I want to achieve that if the result is <=10 it must be FAIL if it is within 11 to 20 it must be APPROVED but if it is => 21 it must say EXCELLENT

This expression works for me but only with one condition... IF([RESULT] =< 10,"FAIL","APPROVED") 😬

in excel I used to do but I'm starting with APPSHEET and I don't get the result I want.

could you give me a hand please?

Thank you very much for your unconditional help.

[TeeSee1 · Accepted solution]

One way to do this

IFS(
 [r] <= 10, "FAIL",
 21  <= [r], "EXCELLENT",
 TRUE, "APPROVED"
)

[Steve]

IFS() - AppSheet Help