Use the MIN function to find the employee with the lowest sales - Basic Statistical Functions - Microsoft Excel Tutorials

Use the MIN function to find the employee with the lowest sales using Microsoft Excel

In a company, employee sales are monitored. Columns B to E contain the sales for the first four months of the year. To determine which employee has the lowest monthly sales, use the MIN function. The function’s return value is the smallest value in a set.

MIN(number1, number2, ...)

number1, number2, ...: From 1 to 30 numbers for which you want to find the smallest value. It is possible to use a cell reference; however, the cells must contain numbers or values that can be converted to numbers.

To determine the lowest monthly sales:

1. In a worksheet, copy the range A1:E10 shown in Figure.
2. Select cells B12:E12 and type the following formula: =MIN(B2:B10).
3. Press <-Ctrl+Enter->.

Use the MIN function to find the employee with the lowest sales

Note: Later you will learn how to automatically shade the smallest value in each column.