Administration and Executive AssistantTier 425 minintermediate

LET for Readable, Reliable Formulas

Name a calculation once inside a formula so every use of it is guaranteed identical.

What you will learn

• Identify a sub-expression that is used more than once in a formula
• Name it once with LET and reference the name for every later use
• Explain why repeating a sub-expression by hand risks a silent mismatch between copies

Excel skills

LET · Formula Readability

The task

Commission is 8% of net profit (revenue minus cost), plus a flat R500 bonus once net profit passes R50,000. Work out each rep's commission on the Deals tab. Net profit appears three times in that sentence, so it needs to appear identically three times in the formula too.

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