The MIN function (which stands for minimum) will return the lowest value in the selected range of cells. MIN functions do not include blank or text entries into the calculations. The syntax for the MIN function is:

=MIN(first value, second value, etc.)

For instance, if we have the following data set given above, the MIN function for the set of scores from Test 1 would be:

=MIN(B4:B9)

To perform an MIN function like the example above, follow the steps below:

• Click in the cell that you want the MIN to be performed (in the above example that will be cell B10).
• Click on the fx button (function button) in the top toolbar.
• Select the Statistical category and click on MIN in the Function name area.

• Click on the OK button.
• Excel will automatically assume you want to average a certain row of cells or columns. If this is the row or column you want averaged, click the OK button. If not, click and drag across the cells you want to include in the average and click OK.

• The MIN score of the range of cells should now appear in the designated cell (in this example "60" is shown in cell B10).