Explanation

This formula uses theMIN functionto make a decision that might otherwise be handled with theIF function.

The number 1000 is supplied as the second value.

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

Excel formula: Cap percentage at 100

Excel formula: Convert negative numbers to zero

Excel formula: Get total from percentage

Excel formula: Get amount with percentage

Excel formula: Get percentage of total

Excel formula: Get percentage discount

Excel formula: Increase by percentage

Excel formula: Decrease by percentage

Excel MIN function