FUNCTION CATALOGUE / LOGICAL
LET Excel function
Names intermediate calculations in a formula.
Correct sentence to use
Calculate [result] using named intermediate values.
Modify this query in PlainFormula →Example formula
=LET(x,A2*B2,x+10)
Assigns names to intermediate values.
Syntax
LET(name1, name_value1, calculation)
Argument signature: name1, name_value1, calculation
Availability note
Available in supported Microsoft 365 / newer Excel versions; verify the exact release and platform.