Divide Sales into 5 groups based on PERCENTRANK

[SammyB]

It's 6am, been up since midnight & my brain is having a hard time working. so I'll ask an easy question:
If I have a list of grades 0-100 & I want to assign a letter grade based on the percentrank, say top 20% is an A, next 20% is a B, next 20% is a C, next 20% is a D, and last 20% is an F. Is there a way to do this without nesting if's.

I know this is a terrible way to grade & I have no intention of doing it. Rather, I want to divide my clients into 5 equal groups based on sales, Outstanding, High, OK, Bad & Miserable. It would be the same formula.

[HansV]

Does this do what you want?

=CHOOSE(5*FLOOR(PERCENTRANK.EXC(grade_range,grade_range), 0.2)+1,"F","D","C","B","A")

[SammyB]

You are amazing! Thanks & A+