I am working on a Spreadsheet to calculate GPA, I have all the formulas I need but right now I have to manually enter in the Point Grade, Letter Grade, and the Class Grade Point. I imported a new sheet that has the range of grade points and the resulting grade letter, and the grade average.
What i'm trying to do is after I input the decimal grade I want it to reference the other sheet to determine which range it falls into and then auto fill the letter grade and the grade point for the class in the appropriate values.
I know just enough about Excel to know that I am completely lost, I remember doing something similar on the Excel Expert 1 MOS exam using an Array? Anyone able to help?
Bookmarks