MIN

Rational

Return the smallest value.

Description

The Excel MIN function returns the smallest numerical with the lowest value as per given reference of cell range.
For example, if A1:A5 contains a list of numbers (2,8,10,5,6) in a column and user want to find the smallest amount, the formula can be =MIN(A1:A5) that find the lowest number as 2.

Syntax

=MIN (number1, [number2], …)

Parameters

number1 – First number or range of cells containing numerical values
number2 [optional] – Second number or range of cells containing numerical values.
The function can handle between 1 to 255 range or criterion pairs.

Return Value

The smallest Integer

Key Notes

• The MIN function returns the lowest among the reference cell.
• Use the MAX function to find the largest value of a data set.
• Arguments can either be numbers or names, arrays, or references that contain numbers.
• MIN returns 0 (zero) if none of the arguments listed value is numeric.
• MIN function ignores empty cells.

MAX

The MAX function returns the highest value as per cell range, if A1:A5 contains a list of numbers (2,8,10,5,6), the formula can be =MAX(A1:A5), returns 10.

AVERAGE

The AVERAGE function returns an average of numbers positioned in one or multiple ranges, =AVERAGE(5,15,30) add numbers and divide by 3, and returns 16.67.

SUM

The SUM function returns a number after adding multiple numeric arguments together =SUM(5,10,15) the Excel add numbers together and returns 30.