Optional Arguments in Excel Lambda

Поделиться
HTML-код
  • Опубликовано: 12 сен 2024
  • A simple short showing how to use an optional argument inside of an Excel Lambda function
    #lambdas #excel #excelshorts

Комментарии • 3

  • @Mark-sf4kh
    @Mark-sf4kh 4 месяца назад +1

  • @ivanmamchych5802
    @ivanmamchych5802 4 месяца назад +1

    Thank you, Victor. However I now wonder what's the purpose of ISOMITTED function. I thought it could be applied for the very this case. Perhaps a combination of IF and ISOMITTED provides us with more flexibility rather then optional arguments in square brackets...

    • @ExcelMoments
      @ExcelMoments  4 месяца назад +1

      You are right about that. The IF ISOMITTED construct would be useful for determining what happens if/when the argument is omitted, but in this case it was just to show that a Lambda can take optional arguments, which i recently realised many people are not aware of