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.
本練習屬於課程
在 Google Sheets 進行貸款攤還
練習說明
- 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.
