Administration and Executive AssistantTier 435 minintermediate

LAMBDA for a Reusable Custom Function

Define a calculation once as your own function, so it behaves identically wherever it is called.

What you will learn

• Write a LAMBDA that takes named parameters and returns a calculated result
• Call a LAMBDA inline, or name it in the Name Manager for reuse across a workbook
• Test a LAMBDA against boundary values to confirm it handles edge cases correctly

Excel skills

LAMBDA · Custom Functions

The task

Bulk discount bands: under 10 units gets no discount, 10 to 49 units gets 5%, 50 units or more gets 12%. Work out the discounted total for every line on the Order tab. Rows of exactly 9, 10, 49 and 50 units are in there on purpose - get the boundary wrong and it will show.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free