Excel FP&A Web Dev Blog

Loading...

Blake Ekelund

Finance ops, half-formed plans, fully-formed spreadsheets.

Work

Excel
FP&A
Web Dev
Blog

Off the clock

Play
On my mindsoon
Golfsoon
MN Sportssoon

Find me

Email
GitHub
LinkedIn

More

Search
Sitemap
Robots

© 2026 Blake Ekelund · Built with Excel, chocky milk, and too many tabs open.

Factorial – Excel LAMBDA | Blake Ekelund

Excel Toolkit›Factorial

Factorial

MathAdvanced

Recursive factorial calculation using LAMBDA recursion.

LAMBDA(n, IF(n <= 1, 1, n * FACTORIAL(n - 1)))

Parameters

n

Example Usage

=FACTORIAL(5)

Pro Tips

Add error trap for negative numbers

Common Issues

Requires recursion to be named in Name Manager

RELATED LAMBDAS IN MATH

Sum of Positive Numbers

Adds only the positive numbers in a range.

LAMBDA(rng, SUM(FILTER(rng, rng > 0)))...