Purchase order...
 

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?

Purchase order...
 

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?

Purchase order...
 

"Bossgobbler" wrote in message
...
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?

=MAX(3%*A1,10)
--
David Biddulph

Purchase order...
 

Worked!!!!! Thank you!

"David Biddulph" wrote:

"Bossgobbler" wrote in message
...
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?

=MAX(3%*A1,10)
--
David Biddulph