# How to Calculate Minimums in Excel

by Kristy Wedel

Excel, part of the Microsoft Office Suite, is a spreadsheet program used to analyze and organize data. Excel includes many statistical functions, such as Trend, Average, Median, Mode, Min and Max. To calculate the minimum in Excel, use the Min function. Excel can calculate the minimum of a range of cells, select cells or a set of numbers.

1

Launch Excel and open the spreadsheet that contains the data for which you want the minimum value.

2

Click on the cell where you want to display the minimum value.

3

To find the minimum value of a continuous range of cells, type the following formula, replacing "first_cell" and "last_cell" with the relevant cell references:

=MIN(first_cell:last_cell)

Then press "Enter." For example, to find the minimum value in cells A1 through A6, you would type:

=MIN(A1:A6)

4

To find the minimum of a set of values in various cells, type the following formula, where "cell1" and "cell2" (etc) are references to cells; you can also enter numbers directly into the formula, instead of cell references:

=MIN(cell1,cell2,...)

Then press "Enter."

For example, to find the minimum value from cells A1 and A14, you would type:

=MIN(A1,A14)

Or, to find the minimum value of the set {2, 3, 11, 15}, type:

=MIN(2,3,11,15)