O'Reilly logo

Microsoft® Office Excel® 2013: Part 1, 2nd Edition by Tim Barnosky

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Basic Function Syntax

In order to understand exactly how an Excel function works, you must understand its syntax. A function's syntax is simply the structure necessary to properly express the function and to define its arguments. As stated earlier, all Excel functions begin with an equal sign followed by the function name. The function name is followed by a set of parentheses that contains the function's arguments; the arguments are separated by commas. Remember that depending on the particular function you are using, arguments can include constants, cell or range references, logical values such as TRUE or FALSE, formulas, and even other functions.

Figure: The basic elements of an Excel function.

Functions can contain both required and ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required