Microsoft Office Tutorials and References

In Depth Information

**BUILT-IN FUNCTIONS**

The data is the same as that shown in Figure E-1, except that Figure E-18 includes a column for the

runners

’

height in inches.

MIN and MAX Functions

The MIN function determines the smallest value in a range of data. The MAX function returns the largest. Say

that we want to know the fastest time for all runners, which would be the minimum time in column G. The

MIN function computes the smallest value in a set of values. The set of values could be a data range, or it

could be a series of cell addresses separated by commas. The syntax of the MIN function is as follows:

MIN(set of data)

To show the minimum time in cell C16, you would enter the formula shown in the formula bar in

Figure E-19:

FIGURE E-19

MIN function in cell C16

(Assume that you typed the label

“

MINIMUM TIME:

”

into cell A16.) You can see that the fastest time is

63 minutes.

To see the slowest time in cell G16, use the MAX function, whose syntax parallels that of the MIN

function, except that the largest value in the set is determined. See Figure E-20.

FIGURE E-20

MAX function in cell G16