| 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) | |||
Hybrid Mode
