| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiply value based on quantity
I am trying to calculate a discount price based on quantity purchased. For
example if someone buys 20 widgets they pay $4.00 each for them, if they buy 50 widgets they pay $4.00 each for the first 20, then $3.50 each for the next 30, 100 widgets - $4.00 first 20, $3.50 next 30 and $3.25 for the other 50.............. Any hope? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trying to multiply data by one cell, based on data of another | Excel Discussion (Misc queries) | |||
| Need a formula to increase quantity of one cell until the quantity ofanother is exceeded | Excel Discussion (Misc queries) | |||
| Total sum based on different costs for each new quantity group | Excel Worksheet Functions | |||
| add value of 4 cells, multiply by 3 subtract 72 multiply by 80% | Excel Discussion (Misc queries) | |||
| excel multiply by different values based on quantity | Excel Discussion (Misc queries) | |||
Threaded Mode
