Forum Discussion
Solved
Help with IFS
Need an IFS formula for Score of L5 to Populate TSHIRT Size in G5 using my Score rank ranges
It's not at all clear that you need an IFS formula.
Instead, what you need is VLOOKUP and a slightly redesigned (inverted, going from low at the top to high at the bottom) Score Rank table. Take a look at this page and see if you can resolve it on your own. If not, come back and ask for help.
