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)

References

About the Author

I have a bachelor’s degree in mathematics from OSU and have written numerous articles on mathematics for eHow. I also have over 5 years experience in computer software/hardware troubleshooting. I have written many software troubleshooting documents as well as user guides for software packages such as MS Office and popular media software.