Tiered commission
=COMMISSION(amount, tier) encapsulates nested IF thresholds sales reps use on every deal row.
What is a named function in Google Sheets?
A named function is a custom formula you define once and call by a friendly name in any cell. Google Sheets uses LAMBDA under the hood via Data > Named functions. Instead of repeating a long expression, you write =DISCOUNT(price, rate) everywhere. Named functions make templates readable and reduce copy-paste errors across tabs.
When to use it
Use named functions when the same calculation appears in dozens of cells: tiered pricing, fiscal quarter labels, custom tax logic, or domain-specific scoring your team shares.
When to skip it
Skip named functions for one-off formulas or when built-in functions already cover the case. Over-abstracting simple math obscures audits.
How it works
-
1
Open Data > Named functions and create a name, argument list, and formula expression using LAMBDA.
-
2
{:"Call the function like a native function"=>"=MYFUNC(A2, B2) in the grid."}
-
3
Arguments map in order to parameters you defined in the LAMBDA signature.
-
4
Update the definition once in Named functions to change behavior workbook-wide.
-
5
Combine named functions with LET inside definitions when intermediate steps clarify logic.
-
6
Document argument units on a README tab so finance can validate the math.
Examples in Google Sheets
Fiscal period label
=FISCAL_MONTH(date) returns Apr-FY25 style strings for pivot groupings without repeating TEXT hacks.
Reusable spill helper
Named function wraps FILTER and SORT so dashboard cells stay one line each.
Build this without starting from a blank cell
Use a Better Sheets tool for Named function, then watch a walkthrough when you want the full pattern.
Better Sheets resources
Common mistakes
- Typos in the function name after editors manually rename calls, causing
- Circular logic inside the named function definition referencing cells that call the function.
- Too many arguments without defaults, making every call error-prone.
- Duplicating Excel UDF expectations that do not port cleanly to Sheets LAMBDA limits.
- Hiding business logic only in named functions with no plain-language definition for auditors.
Frequently asked questions
- Named function vs LAMBDA in cell?
- LAMBDA inline is fine once. Named functions register a reusable name in the workbook UI.
- Share named functions?
- They travel with the spreadsheet file. Copy the file to share; collaborators see the same definitions.
- Named function
- Check spelling, that the function was saved, and that arguments match the defined parameter count.
- Named function and ARRAYFORMULA?
- You can wrap calls in ARRAYFORMULA to fill columns when the named function is row-wise.
- Edit named function safely?
- Change definition in Data > Named functions and spot-check dependent cells before mass rollout.
- Named function vs Apps Script?
- Named functions are formula-speed and stay in the calc engine. Script suits external APIs and mail.
- Import named functions?
- IMPORTRANGE brings values, not function definitions. Define names in each file or use a shared template master.
- LET vs named function?
- LET names variables inside one formula. Named functions name whole reusable formulas for the workbook.
Related Tutorials
Watch how Named function works
Spreadsheet Automation 101: Functions
Related glossary terms
Google Sheets formula syntax
Every formula starts with = followed by a function name and arguments in parentheses. Ranges use A1 notation, text sits in quotes, and operators like + and & combine values. Sheets recalculates when inputs change, so syntax errors show as #NAME? or #ERROR! in the cell.
Read guide →ARRAYFORMULA
ARRAYFORMULA tells Google Sheets to treat a formula as an array operation so one expression fills many cells at once. It is common with IF, VLOOKUP, and math on full columns before dynamic arrays made many patterns automatic. It still matters for legacy sheets and explicit control.
Read guide →visual formulas in Sheets
Visual formulas are spreadsheet layouts where the formula output is meant to be seen, not just calculated: sparkline strips, emoji status icons, color scales, and REPT bars that communicate trend and health at a glance. They sit between raw numbers and full chart objects for dense dashboards.
Read guide →#NAME? error
#NAME? means Google Sheets does not recognize a name in your formula. That can be a misspelled function, a named range that does not exist, text used without quotes, or a function name from the wrong language locale.
Read guide →Done reading about Named function?
Membership unlocks 636+ tutorials, unlimited generators, and every template. Practical lessons. Zero fluff.
Need this once
Jump to a free tool or a single tutorial for this topic.
Learning Sheets for real
Unlock the full library, generators, and templates with membership.