Home

Microsoft Excel [email protected]

Microsoft Excel 2007

Microsoft Excel 2003

Forums

Microsoft Excel 2003 Functions and Formulas

Determine the Largest or Smallest Value in a Series

Summary: These formulas automatically determine the minimum and maximum values in an Excel 2003 data series.

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)

Add: Del.icio.us | Digg | Furl | My Yahoo!

Last Modified on: July 13, 2008, at 12:04 A.M. EDT

Return to the Microsoft Excel 2003 Functions and Formulas page.

Print this tip.

- Subscribe!

Search the Site: