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![]()
Bookmarks