Huh?

The IF and MIN formulae return exactly the same results. Did you try
them?

In article ,
"JR" wrote:

...The IF formula below is the only thing that will work. the "MIN" formulas
mentioned will hold the sales value at 1500.