Purchase order...

B

Bossgobbler

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?
 
E

Elkar

Try the MAX function.

=MAX(A1*.03,10)

This will return whichever value is larger.

HTH,
Elkar
 
D

David Biddulph

Bossgobbler said:
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?
Click to expand...

=MAX(3%*A1,10)
 
Top