


Print article
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.
Books on Microsoft Excel Featured articles Choosing a Cell Phone and Rate Plan  General Articles Stopping Unwanted Email  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. 

Home  Articles  Help  Shop  Business  Education  Contact Us Copyright © 2003 Computertim Technologies. All rights reserved. 