LAMBDA

LogicalMicrosoft 365

Define a reusable custom function from a formula, no VBA.

Syntax

LAMBDA([parameter1, …], calculation)

How it works

Create it in Name Manager (e.g. name it GST), then call it like a built-in: =GST(A2, 18). Also used inline by MAP / REDUCE / BYROW.

Examples

=LAMBDA(amt, rate, amt*rate/100)(1000, 18)

→ 180

Related functions

LET MAP REDUCE BYROW

More Logical functions

AND FALSE IF IFERROR IFNA IFS LET NOT OR SWITCH TRUE XOR

← All 510 functions

Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.