Common Functions

A function is a formula that is already created by Excel.  It can be used to perform a calculation on the data in your worksheet.

Common Functions

Here's a list of the common functions built into Excel.  There is also a description on how to use them.

Sum

What does it do?  Adds a list of numbers.

How do you use it?  =SUM(A1:A4)

This will add cells A1, A2, A3, and A4 and send the results to where you place the formula.

Average

What does it do?  Calculates the average of a list of numbers.

How do you use it?  =AVERAGE(A1:A4)

This will add A1, A2, A3, and A4 and divide it by four.  If you have more or less cells than what is listed, it will divide the sum of the cells by the number of cells.

Max

What does it do?  Find the largest value in a list of numbers.

How do you use it? =MAX(A1:A4)

This function will print the maximum value of the cells in the formula.

Count

What does it do?  Calculates the number of values in a list.

How do you use it?  =COUNT(A1:A4)

This function will calculate the number of values in the cells A1, A2, A3, and A4.

Min

What does it do?  Find the smallest value in a list of numbers.

How do you use it?  =MIN(A1:A4)

This function will print the smallest number of cells A1, A2, A3, and A4.

Round

What does it do?  Rounds a value from a cell to a specific number of digits.

How do you use it?  =ROUND(A1,2)