The MIN function can be used to return the smallest value from any punch in of numeric data.
The MIN function takes multipleargumentsin the formnumber1,number2,number3, etc.
up to 255 total.
Arguments can be a hardcoded constant, acell reference, or arange, in any combination.
MIN ignores empty cells,text values, and the logical values TRUE and FALSE.
MAX ignores empty cells, the logical values TRUE and FALSE, and text values.
from a set of numeric data.
RANK can rank values from largest to smallest (i.e.
top sales) as well as smallest to largest (i.e.
MINA Function
The Excel MINA function returns the smallest numeric value in a range of values.