LET

Unsupported (not recognized)

Category: Logical · Last tested 2026-07-04

Support matrix

Engine	Documented	Live-tested	Verdict
Excel	Yes	Not yet	n/a
Google Sheets	Yes	Not yet	n/a
LibreOffice Calc	No	Yes (24.2.7.2, 2026-07-04)	Unsupported (not recognized)

=LET(x,5,x*2) on LibreOffice Calc returned #NAME?, but the documented/expected result is 10. MISMATCH vs expected: expected 10, got '#NAME?'
=LET(a,2,b,a*3,a+b) on LibreOffice Calc returned #NAME?, but the documented/expected result is 8. MISMATCH vs expected: expected 8, got '#NAME?'
=LET(rng,{1,2,3},SUM(rng)) on LibreOffice Calc returned #NAME?, but the documented/expected result is 6. MISMATCH vs expected: expected 6, got '#NAME?'
=LET(x,5,y,x*2) on LibreOffice Calc returned #NAME?, but the documented/expected result is #VALUE!. LET requires pairs plus a trailing calculation; here the last pair has no calc term following it in this deliberately malformed call; MISMATCH vs expected: expected '#VALUE!', got '#NAME?'

Formula	Description	Result	Expected	Verdict
=LET(x,5,x*2)	Single binding used in the calculation	#NAME?	10	Mismatch
=LET(a,2,b,a*3,a+b)	Later bindings can reference earlier ones in the same LET	#NAME?	8	Mismatch
=LET(rng,{1,2,3},SUM(rng))	LET can bind an array literal and pass it to another function	#NAME?	6	Mismatch
=LET(x,5,y,x*2)	Odd total arg count (missing final calculation expression) is a syntax/value error	#NAME?	#VALUE! LET requires pairs plus a trailing calculation; here the last pair has no calc term following it in this deliberately malformed call	Mismatch