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.

Excel formula: Get next scheduled event

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.

Excel formula: Smaller of two 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.

Excel formula: Cap percentage at 100

MINA Function

The Excel MINA function returns the smallest numeric value in a range of values.

Excel formula: Moving average formula

Excel formula: Total hours that fall between two times

Excel formula: Last row number in range

Excel formula: Split text and numbers

Excel formula: Calculate date overlap in days

Excel formula: Cap percentage at specific amount

Excel formula: Last column number in range

Excel formula: Tiered discounts based on quantity

Excel formula: First column number in range

Excel formula: Value is between two numbers

Excel formula: Odometer gas mileage log

Excel formula: Get earliest and latest project dates

Article image

Article image

Article image

Article image

Article image

Article image

Article image

Article image

Excel MAX function

Excel MINIFS function

Excel SMALL function

Excel RANK function

Excel MINA function

Excel AGGREGATE function