Administration and Executive AssistantTier 925 minadvanced

REDUCE's Initial Value

Track a running peak reading that starts low enough to never be beaten by a negative early reading.

What you will learn

• Use REDUCE with LAMBDA to track a running maximum across a list
• Explain why REDUCE's starting value matters for a running peak
• Recognise that starting from 0 silently overstates an early peak whenever the real readings are negative

Excel skills

REDUCE, LAMBDA · Array Formulas

The task

Daily readings are listed, and the first two days are both negative. Work out the peak reading reached by day 2, in Summary!B3 - a starting point that a negative reading can actually beat.

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