1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Other than setting up CAGR, what’s the LAMBDA function really good for?

I use Excel mainly for creating complex data visualizations and dashboards for enterprise use cases, and secondarily for building models (financials most of the time). I see a function like LAMBDA as something that can help me set up once and go any complex function that I’d have previously needed to set up helper functions or do any computation that involves more than 2 arithmetic notations (Revenue - COGS = basic formula, one notation. Beginning Period - Ending Period ^ # of Periods + Discount Rate bla bla = candidate for LAMDA).

So am I underutilizing LAMDA? What cool use cases do you have for it asides setting up a CAGR computation

submitted by /u/Mo-Mee
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#financial modeling