Autofill with conditions

Copper Contributor

Hello!

I'm hoping I can get help on this discussion board. I'm working on a project that has a few conditions. I previously made a calculator for some work functions to auto-populate GPA based on grade and now I'm not sure how to go about the new adjustment. We now need to change this calculator to auto populate everything based on grade ranges; for example if a person types in 95 then the calculator would populate the grade, gpa, etc. I need these grade ranges for A, A-, B+, etc. with numerous different ranges for each grade.

 

Suggestions on how to go about this?

1 Reply
VLOOKUP with an approximate match.