MIN function

TheMIN functionreturns the smallest numeric value in the data provided.

The MIN function can be used to return the smallest value fromanytype of numeric data.

Otherwise return C5".

Excel formula: Larger of two values

This is a perfectly valid Excel formula, and you will often encounter IF formulas that follow this structure.

The MIN function ignores empty cells, the logical values TRUE and FALSE, and text values.

More than one condition can be tested by nesting IF functions.

Excel formula: Cap percentage at specific amount

Excel formula: Cap percentage at 100

Excel MIN function

Excel IF function

Article image

Article image