Often when developing a Microsoft Excel 2003 spreadsheet you may need to calculate the average of a series of numbers. For example:

* The average amount of revenue a company brought in per month.

* The average test score of a student.

* The average cost to produce a product from several companies' plants.

To do so requires the **=AVERAGE** function. For example:

**=average(99,89,84,92,90)**

would result in the value:

90.8

You could combine this with the =round function to round the average to the nearest whole number, for example with grades:

**=round(average(99,89,84,92,90),0)**

The result:

91

You can also get the average of a series. For example, to get the average of cells A1 through A7:

**=round(average(a1:a7),0)**

*Press the "print" button on your browser or select "File" - "Print" to print this tip. Then, return to Microsoft Excel 2003 Functions and Formulas - Get the Average of a Series.*

Standard disclaimer applies - Read http://tipsforspreadsheets.com/copyright-disclaim.html.