← Recherches et logique
Leçon 1 sur 5
IF: making a formula decide
Ce que vous saurez faire
Write an IF that returns one of two results, combine conditions with AND and OR, and choose IFS over a nested tower.
Ridgeline pays a bonus on orders over $1,000. Thirty-one of the 314 orders qualify. You are not going to find them by eye, and you are not going to mark them by hand every month.
0 XP
Étape 1 sur 6 · 1 point
Line totals are in column J. In K2, return "Bonus" if the order is over 1000 and "No" if it is not.
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | ||||||||||
| 2 | ||||||||||
| 3 | ||||||||||
| 4 | ||||||||||
| 5 | ||||||||||
| 6 | ||||||||||
| 7 | ||||||||||
| 8 | ||||||||||
| 9 | ||||||||||
| 10 | ||||||||||
| 11 | ||||||||||
| 12 | ||||||||||
| 13 | ||||||||||
| 14 |
Cliquez et faites glisser sur des cellules pour voir ici leur Moyenne, leur Nombre et leur Somme.
Rows 1 to 14 of 315
Zone NomK2fx
Votre clavier n'a pas de touche < ou > ? Utilisez celles-ci :