        > Articles Microsoft WindowsMicrosoft WordMicrosoft OutlookMicrosoft ExcelMicrosoft PowerPointMicrosoft FrontPagePalm OSGeneral Articles  Microsoft Excel

## Common Functions

Reader rating: 4 out of 10 Introduction

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)

This function will take the value of A1, round it to 2 decimal places, and print the modified value into the cell where you have put this function.

Note:  All the cell names and other data in the functions can be changed.  We have shown them as they are just to give an example.

Poor   1 - 2 - 3 - 4 - 5 - 6 - 7 - 8 - 9 - 10   Excellent

Books on Microsoft Excel

Featured articles Choosing a Cell Phone and Rate Plan - General Articles Stopping Unwanted E-mail - General Articles Learn about Cookies - Microsoft Windows HotSync Timeout Errors - Palm OS

Also from Computertim Technologies Thoughts on Internet Advertising - an interactive opinion essay by Tim Rooney. Post your opinions on technology and get free computer help in the forums. Tired of AOL? Try Juno for half the price of AOL. Shop for the best deals online at our shopping site.