Function Syntax, Arguments & AutoComplete¶

Every function follows the same grammar. Learn it once and you can read any function — even ones you've never seen.

Excel suggesting a function as the user types

The Universal Pattern¶

excel

5 lines

1=FUNCTION(argument1, argument2, ...)
2│  │        │
3│  │        └─ arguments: the inputs (separated by commas)
4│  └────────── the function name
5└───────────── the = that starts every formula

excel

4 lines

1=ROUND(3.14159, 2)
2       │        │
3       │        └─ 2nd argument: number of decimals
4       └────────── 1st argument: the number to round

Required vs Optional Arguments¶

When you type =ROUND(, Excel shows a ScreenTip:

ROUND(number, num_digits)

Arguments in bold are required.
Arguments in [square brackets] are optional.

AutoComplete Saves Typing¶

1.Type = and the first few letters: =AV
2.Excel lists matching functions (AVERAGE, AVERAGEIF…).
3.Use arrow keys, press Tab to accept.
4.Excel inserts the function and the opening (.

Tip

Press [[Ctrl+Shift+Enter]] is no longer needed in modern Excel — dynamic arrays spill automatically. And [[Ctrl+A]] right after typing a function name opens the Function Arguments dialog with a labeled box for each input.

Nesting Functions¶

A function's argument can itself be a function:

excel

1 line

1=ROUND(AVERAGE(B2:B13), 0)

Excel evaluates inside-out: first AVERAGE, then ROUND rounds that result. You'll nest functions constantly (e.g. IF inside IF, or IFERROR around a VLOOKUP).

The Function Library¶

The Formulas tab groups every function by category — Financial, Logical, Text, Date & Time, Lookup, Math. Browse it when you're not sure a function exists; Excel has 450+.