Excel 2000

Using Functions

Important Term:

• A function is a pre-defined 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.

Syntax Order:

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

An example of a function with one argument:



An example of a function with more than one argument:



Excel has hundreds of different functions (pre-defined 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.