Using the IFS function in Excel 2016 or later when you have multiple conditions. The IFS function returns a value corresponding to the first TRUE condition.
| Join the channel Telegram of the AnonyViet 👉 Link 👈 |
Note: if you are not using Excel 2016 or later, you can nest the IF function.
How to use the Ifs function in Excel
1a. If the value in cell A1 is 1, the IFS function returns Bad.
1b. If the value in cell A1 is 2, the IFS function returns Good.
1 C. If the value in cell A1 is 3, the IFS function returns Excellent.
1d. If the value in cell A1 is equal to another value, the IFS function returns No Valid Score.
Note: instead of TRUE you can also use 1 = 1 or something else that is always TRUE.
2 a. If the value in cell A1 is less than 60, the IFS function returns F.
2b. If the value in cell A1 is greater than or equal to 60 and less than 70, the IFS function returns D.
2 C. If the value in cell A1 is greater than or equal to 70 and less than 80, the IFS function returns C.
2d. If the value in cell A1 is greater than or equal to 80 and less than 90, the IFS function returns B.
2e. If the value in cell A1 is greater than or equal to 90, the IFS function returns A.
