Excel LAMBDA Recursion, recursion, echo...

preview_player
Показать описание
With LAMBDA recursion you can now call functions back on themselves, effectively meaning you can loop up in Excel for the first time!
Рекомендации по теме
Комментарии
Автор

Great! No one would find this creation so easily. All the best. Best wishes for success in all your creations. Cheers. RK

RamakrishnanRukmini
Автор

If you use the comment in the named range, it shows that in the screen tip before the parenthesis. Also once the recursive LAMBDA is named, it can be tested back in the worksheet like normal LAMBDAs. Just put the arguments in parentheses right at the end of the formula

patrickschardt
Автор

Would be great to have Dynamic Waterfall charts with LAMBDA, where the items are dynamic

mauricestillsecret
Автор

Thank you for this great video
but I wonder why it doesn't work with IFS instead of IF

abdelkrimmesaiahmed
Автор

Why not providing the formula or the example workbook?
Here is it. "text" has previously caused problems for me, so I used "cellText" instead:


IF(N=0;"Choose a number greater than 0";

Found"))))

kailash
welcome to shbcf.ru