Purchase order...

[Guest]

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?

 

[Guest]

Try the MAX function.

=MAX(A1*.03,10)

This will return whichever value is larger.

HTH,
Elkar

 

[David Biddulph]

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)

 

[Guest]

Worked!!!!! Thank you!

=MAX(3%*A1,10)