← Nachschlagen und Logik
Lektion 1 von 5
IF: making a formula decide
Was du danach kannst
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
Schritt 1 von 6 · 1 Punkt
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 |
Klicken und ziehen Sie über Zellen, um hier Mittelwert, Anzahl und Summe zu sehen.
Rows 1 to 14 of 315
Name Box (Namenfeld)K2fx
Keine Taste für < oder > auf deiner Tastatur? Nimm diese: