Thread: can I calculate S&H on a sliding scale in an order form?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
wjohnson
 
Posts: n/a
Default 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

Reply With QuoteReply With Quote