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.
Solved! Go to Solution.
One way to do this
IFS(
[r] <= 10, "FAIL",
21 <= [r], "EXCELLENT",
TRUE, "APPROVED"
)
One way to do this
IFS(
[r] <= 10, "FAIL",
21 <= [r], "EXCELLENT",
TRUE, "APPROVED"
)
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
11 |