← Búsquedas y lógica
Lección 1 de 5
IF: making a formula decide
Lo que podrás hacer
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
Paso 1 de 6 · 1 punto
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 |
Haz clic y arrastra sobre las celdas para ver aquí su Promedio, Recuento y Suma.
Rows 1 to 14 of 315
Name Box (Cuadro de nombres)K2fx
¿A tu teclado le falta la tecla < o >? Usa estos: