Microsoft Excel Functions & Formulas

Use the MIN function to find the employee

with the lowest sales

In a company, employee sales are monitored. Columns B to E con-

tain the sales for the first four months of the year. To determine

which employee has the lowest monthly sales, use the MIN func-

tion. 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 refer-

ence; however, the cells must contain numbers or values that

can be converted to numbers.

4

To determine the lowest monthly sales:

1. In a worksheet, copy the range A1:E10 shown in F