All articles with 'let function' Tag
{ 8 Comments }
What is LAMBDA? 4 Practical examples to REALLY understand it
Published on Apr 8, 2022 in Learn Excel
![What is LAMBDA? 4 Practical examples to REALLY understand it](https://chandoo.org/wp/wp-content/uploads/2022/04/excel-lambda.png)
Excel’s LAMBDA() Function let’s you create and share your own functions. It is a true game changer. Learn how to use it with 4 practical examples in this article.
Continue »{ 5 Comments }
Number to Words – Excel Formula
Published on Mar 24, 2020 in Excel Howtos, VBA Macros
![Number to Words – Excel Formula](https://chandoo.org/wp/wp-content/uploads/2020/03/number-to-words-excel-formula.jpg)
Ever wanted to convert numbers to words in Excel? For example, 456,123 becomes four hundred fifty-six thousand one hundred twenty-three.
Microsoft recently introduced LET function to Excel. This allows us to create variables on the fly to use within a formula. I just made a words from number formula using LET function and bit of good old INDEX.
Read on to learn how this all works.
Continue »