Formuladrill

Level 2: Logic and counting Exercise 39 of 118

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.

Functions used: IF, LET

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 exercise

More exercises in Logic and counting