=PERCENTILE({0,65,75,85,95,100},PERCENTRANK({0,65, 90,120,150,180},A1,30))

"sevy" wrote:

I need to convert practice time totals to number grades. Anything from 0 to
65 needs to stay as is, and 66 to 180 minutes need to convert to a range of
grades from 65 to 100. For example, a practice time of 180 minutes should
return 100 as a grade. I know about vlookup, and can get specific cutoffs
such as 180 minutes = 100, 150 minutes = 95, 120 minutes = 85, 90 minutes =
75, and 65 minutes = 65. How do I get the numbers that would fall in between
without having to do an individual lookup for each possible number?