Audio CaptionStartStop

Creating Formulas Using the Min and Max Functions

To use the MIN and MAX Functions:

  1. Select the cell in which you want to enter the function.
  2. Click the Insert Function button.
  3. Select MIN or MAX in the list of functions.
  4. Click OK.
  5. Verify that the range of cells is what you want to find the minimum or maximum value for.
  6. Click OK to insert the function.

To use the MIN or MAX funcion, select the cell where you want to enter the function. Next, click the Insert Function button, then select MIN or MAX from the list of functions and click OK. In the arguments dialog box, verify that the range of cells for your function is correct. At the bottom of the dialog box you will see the result of your function. Click OK to insert the function into your worksheet.