Jan 13 2023 10:33 AM
Jan 13 2023 10:49 AM
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.