You can build Lambda functions in Excel that support optional arguments. A new ISOMITTED function lets you check if the argument was supplied or not.
Transcript of the video:
Learn Excel from MrExcel Podcast episode 2417.
We are now allowed to have optional parameters in our Lambda functions in Excel.
Also a new function called ISOMITTED.
Hey, welcome back to the MrExcel netcast.
I am Bill Jelen.
Today the 7th of the new functions: ISOMITTED. The exciting thing here is that we can now build a Lambda where we can specify that some arguments are optional.
So here I want to pass forecast, actual, and then optionally an indicator which method we're using and the square brackets mean that that is optional.
So then here in the logic we can test if they omitted Method or if they said True for method then we use this formula.
Otherwise we switch over to the other formula.
You can see here in my test here, in the grid I'm passing it B2, B3 and B4 and we get one answer.
I'll press Ctrl+Ditto, (Ctrl and the quotation mark) and take out that optional argument.
By leaving the optional argument out, it reverts to a True thanks to this little bit of logic.
And I get a different answer.
Many functions in Excel allow optional arguments, and now your lambdas can allow them as well.
If you like these videos please down below click Like, Subscribe and Ring the bell.
Feel free to post any questions or comments in the comments below.
I want to thank you for stopping by.
We'll see you next time for another netcast from MrExcel.
We are now allowed to have optional parameters in our Lambda functions in Excel.
Also a new function called ISOMITTED.
Hey, welcome back to the MrExcel netcast.
I am Bill Jelen.
Today the 7th of the new functions: ISOMITTED. The exciting thing here is that we can now build a Lambda where we can specify that some arguments are optional.
So here I want to pass forecast, actual, and then optionally an indicator which method we're using and the square brackets mean that that is optional.
So then here in the logic we can test if they omitted Method or if they said True for method then we use this formula.
Otherwise we switch over to the other formula.
You can see here in my test here, in the grid I'm passing it B2, B3 and B4 and we get one answer.
I'll press Ctrl+Ditto, (Ctrl and the quotation mark) and take out that optional argument.
By leaving the optional argument out, it reverts to a True thanks to this little bit of logic.
And I get a different answer.
Many functions in Excel allow optional arguments, and now your lambdas can allow them as well.
If you like these videos please down below click Like, Subscribe and Ring the bell.
Feel free to post any questions or comments in the comments below.
I want to thank you for stopping by.
We'll see you next time for another netcast from MrExcel.
