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

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.

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

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


=IF(A2<10,A2*8.5,IF(A210,A2*6.5))


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.hightechtalks.com/m390
View this thread: http://www.hightechtalks.com/t2298332