Menu
All articles with 'new excel functions' Tag
{ 5 Comments }
What is LAMBDA? 4 Practical examples to REALLY understand it
Published on Apr 8, 2022 in Learn Excel
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
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 »
