can I calculate S&H on a sliding scale in an order form?

T

TNP

I would like to create a sales order form that calculates a total of the unit
price, sales tax and S&H. S&H varies according to the number of units
purchased. I am using excel 2003.
 
W

wjohnson

You can use the "IF" function up to seven times.
Below is an example for Cell A2 <10 and > than 10 - each time you com
to the"false" value just click on the "IF" Function again - up to seve
times.


=IF(A2<10,A2*8.5,IF(A2>10,A2*6.5)
 
Top