LET Function Transforms Messy Formulas - Comprehensive Guide

Chapters:
0:00 LET Function Syntax
1:51 Using LET for Efficiency
4:41 Referencing Prior Names
8:39 Relative References
13:32 Arrays as Inputs and Outputs
15:54 Debugging

[citrocar]

There're so less number of women on the web doing intellectual and tech work. You're one of those few. Keep it up👏👏👏👏👏!

[suki]

This is such a magic function! And, especially for remembering, as well as transmitting your logic to others, when you look at it at any later time. Also, absolutely clear and precise presentation. I always find your video's very high-level, utterly professional, with plenty of practical, useable examples and pure learning. Thanks, Mynda!

[fliptop]

Last example on debugging rocks! Great way to manually evaluate your formula!

[dltaylormeng]

I had a chemistry problem today I shirked because it would take a few hours to transpose into the right excel form and the resulting formula would look like inpenetrable garbage... this will make a huge difference without having to create a bunch of defined variables. Thanks for the clear walkthrough, and peppering it with a few neat uses of other functions to boot!

[chonzadaniel]

Thanks Mynda, for the articulate demonstration of how the LET function works, providing various scenarios. It's a strong programming concept for Excel users!

[fokhrulislam]

That's the easiest examples to make it understand at once. Thank you.

[josepepe]

Thanks a lot for your presentation and channel. You are one of my favorites "Excel teachers"

[msmith]

Finally got to use LET at work. Thanks for helping me understand it!

[pierreblanchard]

Wonderful ! You show me something useful. You write your formula in many lines by splitting with Alt+Enter. By that, a complexe formula become simple to read. Ex.
=IF(
A1<5;
"good";
IF(A1<10;
"average";
"bad"
)
)

[Deependra]

I am subscriber of leila gharani channel so understood 80% whats going on. So definitely recommend this channel to my friends and subscribed this too.

[anaismartin]

That is a great way to make really complex formulas easier to read for others (and for me when I go back to an old file !)

[georgetosounidis]

Being able to declare variables is a very important step of the new calculation engine.
I see excel starts to look more like a traditional programming language.

[deependragupta]

Now let fn is available i ofc 365 n i have practiced everything shown in video. It took 2 hrs to practice everything as i was forgetting brackets while using filter fn n was giving errors to me. But have to say its great tool to avoid writing formulas again and again n again. Now i can give variable to name and calculation as many time as possible.

[bramble-east]

I don't really know why am I seeing this, but I am glad that Excel users can finally have local variables. Maybe you will even get loops someday, idk...

[anv.]

Perfect function. perfectly explained. appreciated. Thank you so much, dear tutor.

[shawnward]

Wow this is amazing and yet at same time so advanced I will have to watch more than once to understand how you can do this
thanks for videos you and husband are amazing

[aiasaiascon]

This is such a magic function! indeed - this video deserves 1mio

[meniporat]

Hi Mynda, this is indeed an eye-opening lecture.
One very interesting feature of the LET function is that you can use a name within a name.
That is, a name may contain previously defined names in the very same LET function.
For example, in your last illustration:
The "Calc" name refers to ("contains") other predefined names ("Rng", "SelectedBrad", "SelectedCategory").
This feature is very useful, especially when your formula is quite complicated.

[fransvanderwerf]

Simply Excel Brilliantly! I think your excel skills are the biggest contribution to Excel since its introduction Nov 1987. I wish you and your family a Merry Christmas and a very prosperous New Year

[jonsnow]

I've always wanted something like this in Excel in order to reduce the number of times I have to repeat the same formula within a formula. I've always ended up having to use helper cells to make the formula readable. I hope they release to the public soon.