Using Functions

When using Excel functions play an important role in finding values for a range of cells. Learn all about using functions in Excel.

Using functions

Important terms:

  • A function is a predefined formula that helps perform common mathematical functions.

Each function has a specific order, called syntax. Syntax must be followed for the function to work correctly.

To use syntax order:

  1. All functions begin with the equals sign.
  2. After the equals sign is the function name.
  3. One or more arguments are enclosed in parentheses. If there is more than one argument, they are separated by commas.

An example of a function with one argument:

equal sign, function name, argument

An example of a function with more than one argument:

equal sign, function name, argument

Excel has hundreds of functions or predefined formulas to assist you with your calculations. As you know, building individual formulas can be difficult and time consuming. Using Excel's functions can save you a lot of time and headaches.