Forum Discussion
I need to learn how to use the LET function in Excel...
Sounds as if the IFS function (notice the added "S") might be more suitable than plain ol' IF. I don't see why LET would fit -- what makes you think that? LET is very powerful and useful where it fits, but nothing in your description shouts "Let" to my ears. In any event, those two hyperlinks connect you to one of the best resources for researching any Excel functions.
well, I might disagree because depending on what they are checking a LET might help. For example if they need to use a LOOKUP to get a value that then they want to use multiple times in one or multiple conditionals then the LET could be very helpful. Either way, learning LET and IFS and other function is ALWAYS a good idea. I recommend you just do a search for 'tutorial on LET in excel' and you will get lots of options. It depends if you prefer a video like:
https://www.youtube.com/watch?v=PJtHWgq6fTg
or a more text based like:
https://support.microsoft.com/en-us/office/let-function-34842dd8-b92b-4d3f-b325-b8b8f9908999
good luck
IMHO, it all depends on concrete case. Most important points to consider are maintenance and performance. From maintenance point of view LET(), IFS(), SWITCH() and their combinations are more preferrable. But if performance is critical when nested IF is better choice.
