Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tab order in Excel Form? | Excel Discussion (Misc queries) | |||
Order form to BOL? | New Users to Excel | |||
Creating an Order Form....Ragdyer & anyone else? | Excel Discussion (Misc queries) | |||
Order Form | Excel Discussion (Misc queries) | |||
how to make an order form for a Flower sale? | Excel Discussion (Misc queries) |