....I tried the MIN and found that it doesn't account for amounts under 1500.
If you had say, 1385, instead of giving you 1385*.034, it would give you
1500*.034.

"JE McGimpsey" wrote:

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.