On Thu, 22 Dec 2005 07:39:02 -0800, "JR" wrote:

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

Why do you write that?

The MIN formula will return the lesser of the sales value or 1500, which is
what the OP wrote she wanted.
--ron