Name a step with LET
An Excel formula exercise from Formuladrill. Solve it with a formula bar on a live sheet in your browser, and it is checked the moment you submit.
The task
Net sales are sales minus returns. When net sales reach the target in H1 the bonus is 5% of net sales, otherwise it is 0. Use LET to name the net sales once and reuse the name. Fill D2 and D3.
What this exercise teaches
LET gives a name to an intermediate result, so the subtraction is written and calculated once instead of twice. The last argument is the calculation that uses the names.
A hint if you get stuck
LET(name, value, calculation). Write LET(net, B2-C2, ...) and use the word net inside the IF wherever you need the net sales.
Try it now, free, no account needed
Your first 15 exercises on Formuladrill are free. Open it on the practice page, solve it, and get instant feedback with a hint. A free account adds the worked solution; Pro unlocks every exercise, timed mode and the certificate.
Open this exerciseMore exercises in Logic and counting
- Pass or fail
- Letter grades
- Bonus for the north
- Count the shipped orders
- Sales for one region
- Two conditions at once
- Flag for review
- Count with two conditions
- Average for one region
- Scores above a bar
- Best sale in a region
- Shipping tiers
- No more #DIV/0!
- Rank with ties
- Count with a wildcard
- Discount rules
- Average with two conditions
- Sales between two dates
- Plan codes to prices
- Revenue for one region, no helper column
- How many different customers
- One region or the other
- Everything except one status