School grades with IFS()
In this exercise, you will create IFS() formulas to replace VLOOKUP() formulas for school grades.
While VLOOKUP() can perform this lookup, cells need to be appropriately ordered, or the formula will fail.
With an IFS() formula, the conditions can be created in the cell.
Your job is to enter IFS() formulas which can be used to provide a letter grade for any percentage between 0 and 100.
The final default condition for an "F" grade should be 1=1.
Deze oefening maakt deel uit van de cursus
Loan Amortization in Google Sheets
Oefeninstructies
- Enter the
IFS()formula in columnCwhich provides the same value as theVLOOKUP()in columnB. - All of your
IFS()formulas should only use greater than comparisons. No greater than or equal to or less than comparisons. - All grades are integer values. No decimal values can be entered.
Praktische interactieve oefening
Zet theorie om in actie met een van onze interactieve oefeningen.
Begin met trainen