Name a constant
| A | |
|---|---|
| 1 | Net |
| 2 | 200 |
Formula: C1: =LET(tax,0.0825,A2*(1+tax))
Result: 216.5
tax is defined once, then used in the calculation.
Google Sheets function
LET in Google Sheets
LET is supported in Google Sheets, where it can name an intermediate result such as a tax rate or a total.
Syntax (same in Google Sheets)
LET(name1, value1, …, calculation)Sheets also has named functions (Data, Named functions) for logic you want to reuse across many cells.
For a fuller explanation of the arguments and common errors, see the LET Excel guide.
Worked examples in Google Sheets
Reuse a sum
| A | |
|---|---|
| 1 | Share |
| 2 | 25 |
| 3 | 50 |
| 4 | 25 |
Formula: C1: =LET(total,SUM(A2:A4),A2/total)
Result: 0.25
total is calculated once and reused; here 25 / 100.
Intermediate result in a test
| A | B | |
|---|---|---|
| 1 | Spend | Budget |
| 2 | 120 | 100 |
Formula: D2: =LET(ratio,A2/B2,IF(ratio>1,"Over","Within"))
Result: Over
ratio is named once and used in the IF.
Try it
A tiny spreadsheet with example data. Edit the formula or any number and see the result.
Formula in F2: =LET(total,SUM(C2:C7),total/COUNT(C2:C7))
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Region | Product | Units | Price | Result | |
| 2 | East | Pen | 120 | 2.5 | 58.3333333333 | |
| 3 | West | Pen | 80 | 2.5 | ||
| 4 | East | Book | 45 | 12 | ||
| 5 | North | Book | 60 | 12 | ||
| 6 | West | Lamp | 30 | 25 | ||
| 7 | East | Lamp | 15 | 25 |
Result in F2: 58.3333333333
Frequently asked questions
- What is the difference between LET and a named function in Google Sheets?
- LET names values inside one formula. A named function packages a whole calculation under its own name so other cells can call it.
Google Sheets is used here only as a descriptive product name. FormulaCamp is not affiliated with Google.