What is a function in Excel? Definition and formula vs function

Microsoft's definition adds the part people forget: "Functions are predefined formulas that perform calculations by using specific values, called arguments, in a particular order, or structure." Predefined, and in a particular order. You did not write SUM and cannot change what its arguments mean — which is why a function is reliable, and why getting its arguments in the wrong order is such a common way to be confidently wrong.

Formula or function?

This is the distinction most searches are really after, and Exceljet draws it in two sentences: "Technically, a formula is any expression that begins with an equals sign (=). A function, on the other hand, is a formula with a special name and purpose."

So the two words are not alternatives. A function is a particular kind of thing a formula can contain.

	Formula	Function
What it is	Any expression in a cell that starts with =	A named, predefined calculation
Who wrote it	You	The application
Example	=B2*1.2	SUM, VLOOKUP, TEXTJOIN
Can contain the other	Yes — a formula may call many functions, or none	Yes — a function's arguments may be formulas

=B2*1.2 is a formula containing no functions. =SUM(B2:B12) contains one. =ROUND(SUM(B2:B12)/COUNT(B2:B12),2) contains three. All three are formulas; only the last two involve functions.

The anatomy of a function

Microsoft describes the shape precisely: "The structure of a function begins with an equal sign (=), followed by the function name, an opening parenthesis, the arguments for the function separated by commas, and a closing parenthesis." Exceljet's summary is the one to keep in your head: =NAME(argument1,argument2,argument3).

The parentheses are not decoration. They mark where the inputs begin and end, which is how a spreadsheet knows that in =ROUND(SUM(A1:A9),2) the 2 belongs to ROUND and the range belongs to SUM. They stay even when there is nothing to put in them — Microsoft's overview uses PI(), which takes no arguments and still needs its brackets.

Inside them go the arguments, and Microsoft's list of what one may be is broader than most people assume: "Arguments can be numbers, text, logical values such as TRUE or FALSE, arrays, error values such as #N/A, or cell references … Arguments can also be constants, formulas, or other functions." Exceljet adds the convention documentation uses: optional arguments are "shown in square brackets [ ]". Which arguments each function takes, and which may be left out, is a subject of its own, covered under Function arguments.

Categories, and how many there are

Nobody learns them as a list. Exceljet notes that "Excel contains hundreds of specific functions", and the practical route in is by category — you look for the family that matches the job.

Google's function list maps the categories both applications share, grouping functions as Array, Database, Date, Engineering, Filter, Financial, Info, Logical, Lookup, Math, Operator, Parser, Statistical, Text and Web, plus its own additions. The Operator category is a reminder that the boundary is softer than it looks: the symbols described under Operators and precedence have named function equivalents too.

Nesting

A function's arguments can themselves be functions, which is how small pieces become models. Exceljet states the principle: "The output of any formula or function can be fed directly into another formula or function." Microsoft adds the constraint: "When a nested function is used as an argument, the nested function must return the same type of value that the argument uses … If the function doesn't, Excel displays a #VALUE! error value."

Evaluation runs inside out, which Google states plainly: "A function used in the same cell with another function is called a nested function. When functions are combined, Google Sheets will calculate the innermost function first."

There is a documented ceiling. Microsoft: "A formula can contain up to seven levels of nested functions." In practice the readability ceiling arrives long before the technical one — a formula three levels deep is already something most people reconstruct from scratch each time they open it.

Excel and Google Sheets

The overlap is large and deliberately so. Google's framing is that "Google Sheets supports cell formulas typically found in most desktop spreadsheet packages", and the everyday functions — SUM, IF, VLOOKUP, TEXTJOIN, FILTER — carry the same names and broadly the same arguments in both.

Where they part company is at the edges, and the clearest case is Google's own category of functions with no Excel counterpart: GOOGLEFINANCE for securities data, GOOGLETRANSLATE for translation, IMPORTRANGE for pulling a range out of another spreadsheet, and IMPORTHTML and IMPORTXML for pulling data off the web. These exist because Sheets is a web application, and a workbook built on them does not convert to Excel at all.

Sheets also puts documentation where you are typing. Google describes a "function help box" that stays "visible throughout the editing process to provide you with a definition of the function and its syntax, as well as an example for reference" — which is why Sheets users tend to learn unfamiliar functions in the cell rather than in a browser tab.

How Formula Foundry handles this

Formula Foundry's editor is built around the fact that a function has a knowable shape. As you type a name it auto-suggests from the function list, and it colour-codes what you have written by what it is — functions, ranges, constants and named references each get their own colour, so a misspelled function name reads as the wrong colour before it ever reads as #NAME?. Matching parentheses highlight, which on a three-level nest is the difference between counting brackets and seeing them.

The visual formula builder takes the anatomy literally, rendering a formula's call tree as a form: every argument labelled with its name, nested calls shown as nested groups, fields validated as you fill them, and a live preview of what you are assembling. For the function you use twice a year — the one whose fourth argument you always look up — it removes the lookup. In the other direction, the AI assistant turns a plain-English description into a formula, and explains an inherited one step by step. Explain sends only the formula text, and only when you click it.

Two honest limits. Formula Foundry never evaluates your workbook: it parses, formats, translates and explains, so it can tell you a function call is malformed but not that its result is wrong. And its @@variables are the add-on's own layer, not a spreadsheet feature — a value you define once in the sidebar and use as @@TaxRate, substituted before the formula reaches the cell. That is a different mechanism from the spreadsheet's own LET, which names values inside a single formula. The features overview covers the editor, the builder and the assistant.

FAQ