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.