📎 This article includes 1 downloadable practice file ↓
In this article
REDUCE is SCAN that returns only the final result — useful for repeated clean-up steps.
Syntax
=REDUCE(initial_value, array, LAMBDA(acc, value, calculation))| Argument | What it means |
|---|---|
array |
Values to process one by one. |
Examples
Example 1
=REDUCE(A2, {"-","/"," "}, LAMBDA(t, c, SUBSTITUTE(t, c, "")))Remove several characters from a code in one formula.
REDUCE in practice
Where you will use it
- Running calculation that returns one value
- Apply several replacements in turn
- Custom totals
Worked example
| Case | Formula | Result |
|---|---|---|
| 1 | =CHOOSE(A2,REDUCE(0,{1,2,3,4},LAMBDA(a,v,a+v^2)),REDUCE(1,{1.1,1.2,0.9},LAMBDA(a,v,a*v)),REDUCE("Shimti Pune",{"Shimti","Pune"},LAMBDA(a,v,SUBSTITUTE(a,v,UPPER(v))))) | 30 |
| 2 | =CHOOSE(A3,REDUCE(0,{1,2,3,4},LAMBDA(a,v,a+v^2)),REDUCE(1,{1.1,1.2,0.9},LAMBDA(a,v,a*v)),REDUCE("Shimti Pune",{"Shimti","Pune"},LAMBDA(a,v,SUBSTITUTE(a,v,UPPER(v))))) | 1.188 |
| 3 | =CHOOSE(A4,REDUCE(0,{1,2,3,4},LAMBDA(a,v,a+v^2)),REDUCE(1,{1.1,1.2,0.9},LAMBDA(a,v,a*v)),REDUCE("Shimti Pune",{"Shimti","Pune"},LAMBDA(a,v,SUBSTITUTE(a,v,UPPER(v))))) | SHIMTI PUNE |
Results calculated in Excel.
Mistakes people make
| Mistake | What to do instead |
|---|---|
| Accumulator first | LAMBDA(acc, value, ...) |
| Need every step | Use SCAN |
Related functions
SCAN · LAMBDA · SUBSTITUTE
📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.
⚡ Interactive Practice Lab & Formula Tester:
Test formulas dynamically in our web formula laboratory or download the companion Excel workbook.
📎 Practice files for this article
- 📗Practice workbook: Logic, LET & LAMBDA17 tasks on realistic sales data — type your formula, the Check column turns green when it is right. Answers sheet included.⬇ XLSX · 35 KB
Free to use for learning. Files with macros (.bas) are plain text — import them with Alt+F11 → File → Import File, and always test on a copy.
✨ Ask AI about this article
Stuck on a step? Ask a question and the AI answers using this article.
Free · AI can be wrong