★0 XP
Question 1 of 10
The IFS function allows you to test multiple criteria and return a value corresponding with the FIRST true condition. Let's say employees get a $1,000 bonus if they close 5 or more deals, $500 if they close 3 or more deals, and $0 if they close fewer than 3 deals.
The IFS function evaluates the criteria in order and returns the first true option. Try typing =IFS(B2>=5, 1000, B2>=3, 500, B2<3, 0) to calculate John's bonus.
The IFS function evaluates the criteria in order and returns the first true option. Try typing =IFS(B2>=5, 1000, B2>=3, 500, B2<3, 0) to calculate John's bonus.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | EMPLOYEE | DEALS | ||
| 2 | John | 1 | ||
| 3 | Sarah | 4 | ||
| 4 | Max | 5 | ||
| 5 | Michael | 3 |
D1fx