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.