LET function

GPTKB entity

Statements (18)
Predicate Object
gptkbp:instanceOf Excel function
gptkbp:advantage improves formula performance
improves formula readability
gptkbp:category Logical function
gptkbp:documentation https://support.microsoft.com/en-us/office/let-function-34842dd8-b92b-4d3f-b325-bd5c8c3bf265
gptkbp:example LET(x, 1+2, x*5) returns 15
gptkbp:hasSyntax LET(name1, value1, [name2, value2, ...], calculation)
https://www.w3.org/2000/01/rdf-schema#label LET function
gptkbp:introducedIn gptkb:Excel_2021
gptkb:Excel_for_Microsoft_365
gptkbp:limitation not available in Excel 2019 or earlier
gptkbp:maximumVariables 126
gptkbp:purpose define named variables in formulas
gptkbp:relatedTo gptkb:LAMBDA_function
DEFINE NAME
gptkbp:usedIn gptkb:Microsoft_Excel
gptkbp:bfsParent gptkb:Excel
gptkbp:bfsLayer 5