Excel & Sheets practice: Multi-Branch Decision Engines

Chapter 3 · 2 questions · free to solve

Question 1 · medium
Order size bands with IFS
Band every order by Units: 40+ → "Bulk", 15–39 → "Standard", anything smaller → "Small". Use IFS, starting in K2 and filling to K21.
Solve it in your browser
Question 2 · medium
Region codes with SWITCH
Map each Region to a code — North N-01, South S-02, West W-03, and anything else E-04. Use SWITCH in K2, filled to K21.
Solve it in your browser

These questions are free.

Make a free account to solve them, with instant checking and an AI tutor for hints.

Order size bands with IFS