REDUCE Function in Excel: Syntax, Examples and Free Practice
REDUCE is an Excel Logic function. Reduces an array to a single accumulated value using a LAMBDA.
REDUCE syntax
Arguments
initial_value: The starting value before the calculation begins (optional)array: The range or array to evaluatelambda: The expected rate of occurrence
When to use REDUCE
REDUCE is used to build decision rules directly into a spreadsheet instead of manually judging each row.
Practice REDUCE online, free
Open the live Excel-style spreadsheet and try REDUCE yourself. No Excel install or sign-up needed to start.
Practice REDUCE now →More Logic functions
Frequently asked questions
What does the REDUCE function do in Excel?
Reduces an array to a single accumulated value using a LAMBDA.
What is the syntax of REDUCE in Excel?
The syntax is =REDUCE([initial_value], array, lambda). initial_value: The starting value before the calculation begins (optional); array: The range or array to evaluate; lambda: The expected rate of occurrence.
Where can I practice REDUCE online for free?
Open the free live spreadsheet on Cellgrids and try REDUCE yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Logic functions · Excel case studies · Excel tutorials · Excel shortcuts