Try the MAX function.

=MAX(A1*.03,10)

This will return whichever value is larger.

HTH,
Elkar


"Bossgobbler" wrote:

I have set up a purchase order workbook. What I want to do is have the
shipping and handling cell calculate 3% of the subtotal or $10.00 (there is a
10 dollar minimum). I can do either or but don't know how to do both. If
it's not too complicated or time consuming, can it be done?