Often when creating a Microsoft Excel 2003 you may need to figure out the largest or smallest value in a series of data. To do so requires the =max or =min function, respectively. The syntax:

**=max(SERIES_OF_DATA)**

**=min(SERIES_OF_DATA)**

* SERIES_OF_DATA can either be a comma-delimited set of numbers or a series of cells, such as a1:a5.

For example, assume a spreadsheet's column 'i' contains a series of expense values. The following formula, when placed in a column outside 'i', determines the largest expense:

**=max(i:i)**

And the following formula, when placed in a column outside 'i', determines the smallest expense:

**=min(i:i)**

*Press the "print" button on your browser or select "File" - "Print" to print this tip. Then, return to Microsoft Excel 2003 Functions and Formulas - Determine the Largest or Smallest Value in a Series.*

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