(8) How to use MIN formula in Microsoft Excel.
MIN: MIN Function returns the smallest number in a set of values.
=MIN(RANGE)
Example:
Give the formula in B11 cell.
Formula |
Description |
Result |
=MIN(B2:B10) |
Returns the smallest number in a set of values.
here, RANGE=B2:B10. You can use any range as per your requirement. |
80
|
=MIN(B2,B3,B4,B5,B6,B7,B8,B9,B10) |
Returns the smallest number in a set of values.
|
80
|
=MIN(85,80,80,85,95,85,80,80,85) |
Returns the smallest number in a set of values. |
80
|
Video:
How to use MIN formula in Microsoft Excel:
|