LET

Assigns names to values in a formula.

Excel: Verified match
Google Sheets: Verified match
Returns: Any value

Examples

=LET(x, 2, x * 10)

Result 20

Syntax

LET(name1, name_value1, calculation_or_more…)

name1: any required
name_value1: any required
calculation_or_more…: any required

Errors

#ERROR!: =LET(x,1,x,2,x)

ARRAY_CONSTRAINTruncates a range to at most the given rows and columns. ARRAYFORMULAEvaluates an expression across a range (this engine already spills, so it is a pass-through for sheets compatibility). ARRAYTOTEXTConverts array to text representation. BYCOLApplies lambda to each column of array. BYROWApplies lambda to each row of array. CHOOSECOLSReturns the specified columns from an array.