Then you entered either the formula or the 1385 incorrectly. Did you by
chance enter:

=MIN(A1, 1500*0.034)

instead of

=MIN(A1, 1500) * 0.034

????



In article ,
"JR" wrote:

...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.