Logical

LET function

Name values for a calculation. LET works in Sheets with the usual arguments and results, on cells and on live data from the tools you connect.

Syntax

=LET(name1, value1, [name2, value2, ...], calculation)

Argument	Use
`name1`	required, repeatable
`value1`	required, repeatable
`name2`	optional, repeatable
`value2`	required, repeatable
	required
`calculation`	required

Example

Name intermediate results to keep a formula readable.

fx=LET(paid, SUMIF(D2:D7, "Paid", E2:E7), total, SUM(E2:E7), paid/total)

	A	B	C	D	E	F
1	Order	Customer	Region	Status	Amount	Date
2	#1001	Acme Ltd	North	Paid	1200	2026-01-14
3	#1002	Blue Fox	South	Open	450	2026-01-20
4	#1003	Acme Ltd	North	Paid	980	2026-02-03
5	#1004	Cedar & Co	East	Overdue	2300	2026-02-11
6	#1005	Blue Fox	South	Paid	610	2026-03-02
7	#1006	Delta BV	West	Open	1750	2026-03-09
8	0.3827

Result computed by the Sheets formula engine.

On live data

In Sheets, LET sits next to live data from a connected tool: =data.orders.sum(total) totals a table, =list.orders(customer) spills a column's distinct values, and a linked table column such as table.orders[Total] is a range any function accepts.

See the integrations

More logical functions

ANDTRUE if all are TRUE IFConditional IFERRORFallback if value errors IFSFirst value whose condition is TRUE ORTRUE if any is TRUE SWITCHResult for the matching value BYCOLApply a LAMBDA to each column BYROWApply a LAMBDA to each row FALSEThe logical value FALSE IFNAFallback if value is #N/A ISOMITTEDTRUE if a LAMBDA argument is missing LAMBDAA reusable function

All 20 logical functions →

Spreadsheet formulas on live business data

Sheets evaluates 491 spreadsheet functions, on cells and on data read live from your tools.

See the integrations