### Introduction

A **function** is a **predefined formula** that performs calculations using specific values in a particular order. Every spreadsheet programs include typical functions that can be provided for easily finding the **sum**, **average**, **count**, **maximum value**, and **minimum value** because that a variety of cells. In order to use attributes correctly, you'll need to recognize the various **parts the a function** and also how to create **arguments **to calculate values and cell references.

You are watching: Excel features built-in, preprogrammed formulas called

Watch the video clip below to learn an ext about using attributes in Excel.

The parts of a function

In stimulate to work correctly, a function must be written a particular way, i beg your pardon is called the **syntax**. The an easy syntax for a duty is one **equals authorize (=)**, the **function surname **(SUM, because that example), and one or more **arguments**. Arguments contain the info you want to calculate. The duty in the example below would add the worths of the cell range A1:A20.

Working v arguments

Arguments have the right to refer come both **individual cells** and also **cell arrays **and should be enclosed within **parentheses**. You can incorporate one debate or multiple arguments, depending upon the syntax forced for the function.

For example, the function **=AVERAGE(B1:B9) **would calculate the **average** of the values in the cell range B1:B9. This duty contains only one argument.

Multiple debates must be separated by a **comma**. For example, the role **=SUM(A1:A3, C1:C2, E2) **will **add** the values of all cells in the three arguments.

### Using functions

There space a variety of functions. Right here are some of the most usual functions you'll use:

**SUM**: This role

**adds**every the values of the cell in the argument.

**AVERAGE**: This role determines the

**average**that the values included in the argument. It calculates the amount of the cells and then divides that worth by the variety of cells in the argument.

**COUNT**: This duty

**counts**the number of cells with numerical data in the argument. This duty is advantageous for easily counting item in a cell range.

**MAX**: This function determines the

**highest**

**cell value**contained in the argument.

**MIN**: This role determines the

**lowest cell value**consisted of in the argument.To usage a function:

In our instance below, we'll use a basic duty to calculate the **average price** **per unit **for a perform of newly ordered items using the mean function.

**cell**that will contain the function. In our example, we'll select cell

**C11**.

Type the

**equals sign (=)**and enter the wanted

**function name**. In our example, we'll type

**=AVERAGE**.

Enter the

**cell range**for the

**argument**inside

**parentheses**. In our example, we'll form

**(C3:C10)**. This formula will include the values of cells C3:C10 and also then division that value by the total variety of cells in the selection to recognize the average.

Press

**Enter**on your keyboard. The function will it is in

**calculated**, and the

**result**will appear in the cell. In our example, the median price per unit of items ordered was

**$15.93**.

Your spreadsheet **will not always tell you** if your duty contains one error, so it's approximately you come check all of your functions. To learn just how to do this, inspect out the Double-Check her Formulas lesson.

### Working through unfamiliar functions

If you desire to learn how a duty works, you can **start inputting that function in a blank cell** to watch what that does.

See more: What Was The Center Of Life In New England Life? What Was The Center Of Life In New England

### Understanding nested functions

Whenever a formula includes a function, the function is typically **calculated before** any kind of other operators, prefer multiplication and also division. That's due to the fact that the formula treats the entire role as a single value—before it deserve to use that worth in the formula, it needs to operation the function. For example, in the formula below, the SUM role will it is in calculated prior to division:

Let's take it a look in ~ a more complex example that supplies multiple functions:

**=WORKDAY(TODAY(),3)**

Here, we have two different functions functioning together: the WORKDAY function and the now function. These are recognized as **nested functions**, due to the fact that one role is placed, or **nested**, in ~ the disagreements of another. As a rule, the nested role is **always calculate first**, as with parentheses room performed first in the bespeak of operations. In this example, the TODAY role will be calculated first, since it's nested in ~ the WORKDAY function.

### Other common functions

There room **many various other functions** you can use to conveniently calculate various things through your data. Learning how to usage other features will permit you come solve facility problems v your spreadsheets, and we'll it is in talking more about them transparent this tutorial. You can additionally check out our short articles below to learn about particular functions: