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.
