Calculate Weighted High School GPA with Excel ISERROR and XLOOKUP Functions

Use a variety of Excel functions (IF, ISERROR, FIND, and XLOOKUP) to calculate a weighted GPA if the student has taken some AP courses in addition to regular courses. AP courses may get a higher grade point value per course than standard courses. #excel #iserror #if #find #xlookup

[brendanknight]

How would you write this if you had a different weight for On Level, Honors and AP. So three sets of criteria vs just two?