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.
