Excel & Sheets practice: Variable-Driven Formulas with LET

Chapter 28 · 3 questions · included in full access

Question 1 · medium
Share of revenue with LET
In K2, return the Region in M1's share of total revenue, using LET to name the total and the region's part.
Solve it in your browser
Question 2 · medium
Tiered discount with LET
Discounted revenue: 10% off orders of 40,000+, 5% off 20,000–39,999, no discount below. Use LET so Revenue is referenced once. Start in K2, fill to K21.
Solve it in your browser
Question 3 · medium
Bad LET names
Which LET variable name will cause an error?
Solve it in your browser

These questions are part of full access.

The first chapters of every track are free. Full access is a one-time payment.

Share of revenue with LET