LAMBDA

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)

=LAMBDA(x,x*2)(5) on LibreOffice Calc returned #VALUE!, but the documented/expected result is 10. MISMATCH vs expected: expected 10, got '#VALUE!'
=LAMBDA(x,y,x+y)(3,4) on LibreOffice Calc returned #VALUE!, but the documented/expected result is 7. MISMATCH vs expected: expected 7, got '#VALUE!'
=LET(f,LAMBDA(x,x^2),f(4)) on LibreOffice Calc returned #NAME?, but the documented/expected result is 16. MISMATCH vs expected: expected 16, got '#NAME?'

Formula	Description	Result	Expected	Verdict
=LAMBDA(x,x*2)(5)	Immediately-invoked LAMBDA with one parameter	#VALUE!	10	Mismatch
=LAMBDA(x,y,x+y)(3,4)	LAMBDA with two parameters	#VALUE!	7	Mismatch
=LET(f,LAMBDA(x,x^2),f(4))	LAMBDA bound to a name via LET, then called	#NAME?	16	Mismatch
=LAMBDA(x,y,x+y)(3)	Calling with fewer arguments than parameters is an error	#VALUE!	#VALUE!	Matched