Min function and Max function Excel Tutorial

This is a Microsoft Excel tutorial on how to use min and max function in Excel 2007 and 2010. Min function will give you the lowest value in an area, max will give you the highest value in an area. To use these functions, follow these simple steps:

Min function and Max function Excel Tutorial

Min function 

  1. Click on the cell you wish to show the lowest value.
  2. Go to Home tab and click the down arrow near the autosum button. Select Min from the list.
  3. Select the cells you wish to get the lowest value out of and press enter.

Max function 

  1. Click on the cell you wish to show the lowest value.
  2. Go to Home tab and click the down arrow near the autosum button. Select Max from the list.
  3. Select the cells you wish to get the highest value out of and press enter.

1 comment:

  1. Thanks for sharing this quality information with us. I really enjoyed reading. Will surely going to share this URL with my friends. Microsoft Excel Training Courses Malaysia

    ReplyDelete