http://www.bing.com:80/search?q=Let+Function+ExcelSearch resultshttp://www.bing.com:80/s/a/rsslogo.gifhttp://www.bing.com:80/search?q=Let+Function+ExcelCopyright © 2026 Microsoft. All rights reserved. These XML results may not be used, reproduced or transmitted in any manner or for any purpose other than rendering Bing results within an RSS aggregator for your personal, non-commercial use. Any other use of these results requires express written permission from Microsoft Corporation. By accessing this web page or using these results in any manner whatsoever, you agree to be bound by the foregoing restrictions.https://techcommunity.microsoft.com/blog/excelblog/announcing-let/1233572LET Function release in Excel This formula can be authored traditionally using the following formula. However, this formula suffers from a common occurrence where you have to make use of the same expression twice, in this case it’s the FILTER expression. By using a LET we can abstract on this value and even add an addition to fix up the criteria, which in this case is “Fred” but you ...Fri, 10 Apr 2026 21:28:00 GMThttps://techcommunity.microsoft.com/discussions/excelgeneral/let-and-nested-dynamic-array-filter-function/3035856The local variable, here A₀, can be used for on-going calculation within the LET function, or the LET itself may be nested within further formulae. If you require the result to be in the form of a range reference, you could place the formula on a distant sheet and address the spilt helper range.Tue, 07 Apr 2026 07:06:00 GMThttps://techcommunity.microsoft.com/blog/excelblog/let---names-in-formulas---generally-available/1878903LET is now generally available in Production. Learn more about names in formulas and tips and tricks to level up your formula authoring skills.Wed, 08 Apr 2026 22:13:00 GMThttps://techcommunity.microsoft.com/discussions/excelgeneral/let-function-used-with-index-/2383781Let function used with Index. Hi, I try to figurer out how to use the new LET function, in this example wich has the same INDEX function several times. Is it possible, if yes, aht is the solution? Example file is attached. Best regards - GeirTue, 31 Mar 2026 06:24:00 GMThttps://techcommunity.microsoft.com/discussions/excelgeneral/unexpected-error-with-let-function/1531431Please note this function is in Beta mode, that means bugs could appear in some scenarios, plus function behaviour on time of general availability could be slightly different from what we have now. That's normal process, so far we use the function (as any other beta ones) on our own risk, even if such risk is relatively small.Fri, 20 Mar 2026 03:31:00 GMThttps://techcommunity.microsoft.com/discussions/excelgeneral/countif-not-working-with-arguments-defined-by-let-function/4193584Excel Your community for how-to discussions and sharing best practices on Microsoft Excel. If you’re looking for technical support, please visit Microsoft Support Community.Wed, 01 Apr 2026 04:21:00 GMThttps://techcommunity.microsoft.com/discussions/excelgeneral/excel-365-let-function-not-recognized/1862830Hi,I just upgraded to Office 365 ProPlusThe LET function is not available.Does anybody know how to fix this issue?\\Thank you Mon, 23 Mar 2026 04:24:00 GMThttps://techcommunity.microsoft.com/discussions/excelgeneral/dynamic-let-function/4362078Dynamic Let Function If you have a long let function with lots of variables, it is annoying to audit. It is also a shame that all the other info in the let function is "trapped" without manually going in to change the item ment to be returned.Wed, 18 Mar 2026 23:07:00 GMThttps://techcommunity.microsoft.com/discussions/excelgeneral/let-%e2%80%93-names-in-formulas-for-excel/1444083LET – Names in formulas for Excel Hello all, I'm excited to share with you a new function that has been recently released, Names in formulas or =LET (). The LET function will now allow you to name and then use a calculation or value in your formulas. This will allow you to increase both readability and performance.Mon, 23 Mar 2026 02:51:00 GMThttps://techcommunity.microsoft.com/discussions/excelgeneral/recursive-lambda-unpacking-let-function/2132456LAMBDA: The ultimate Excel worksheet function - Microsoft Research I wasn't really serious in suggesting that the task should be performed, simply making the point that it could be performed. I was simply expressing the idea that reducing a LET function to traditional spreadsheet formulae (that I know and loath) is a purely mechanistic process.Fri, 20 Mar 2026 01:50:00 GMT