software

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?

Try the MAX function.

=MAX(A1*.03,10)

This will return whichever value is larger.

HTH,
Elkarquot;Bossgobblerquot; wrote:

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

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

=MAX(3%*A1,10)
--
David Biddulph
Worked!!!!! Thank you!

quot;David Biddulphquot; wrote:

gt; quot;Bossgobblerquot; gt; wrote in message
gt; ...
gt; gt;I have set up a purchase order workbook. What I want to do is have the
gt; gt; shipping and handling cell calculate 3% of the subtotal or $10.00 (there
gt; gt; is a
gt; gt; 10 dollar minimum). I can do either or but don't know how to do both. If
gt; gt; it's not too complicated or time consuming, can it be done?
gt;
gt; =MAX(3%*A1,10)
gt; --
gt; David Biddulph
gt;
gt;
gt;