Hello,

I'm trying to do data as following with Excel 2016:

Score 0-16 , result is Superior
Score 17-100, result is Average
Score above 101, result is Low

However I don't understand how IFS function works yet. My formula as below:


=IFS(G16<=16,"Superior",G16>16,"Average",G16>100,"Low")


Please help to advise what should I correct.

Thank you