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".
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.