| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pricing Tiers Help
(Excel 2003)
Pricing Scenerio: Unit = $1,000 1 Unit also = 1 Year subscription Can buy multiple years and/or multiple Units for the same year. Think of it as dowloading music. I can buy the right to listen to a song for a year, or that same song for two years. Or I can buy multiple songs. Each can have its own length of time. [A1] contains the number of units they want priced [B1] contains the unit value [C1] contains the number of years [D1] would contain the outbut Pricing Rule#1 Every 10 Units Get One Free (Pertains to cell [A1]) Pricing Rule#2 If a unit is purchased for 3 Years instead of one or two, they gets 20% Discount Can you please help me setup the formulas? Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pricing Tiers Help
See if this is what you're looking for:
=(A1-ROUNDDOWN(A1/10,0))*B1*C1*(IF(C1=3,0.8,1)) HTH, Elkar "dj479794" wrote: (Excel 2003) Pricing Scenerio: Unit = $1,000 1 Unit also = 1 Year subscription Can buy multiple years and/or multiple Units for the same year. Think of it as dowloading music. I can buy the right to listen to a song for a year, or that same song for two years. Or I can buy multiple songs. Each can have its own length of time. [A1] contains the number of units they want priced [B1] contains the unit value [C1] contains the number of years [D1] would contain the outbut Pricing Rule#1 Every 10 Units Get One Free (Pertains to cell [A1]) Pricing Rule#2 If a unit is purchased for 3 Years instead of one or two, they gets 20% Discount Can you please help me setup the formulas? Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pricing Tiers Help
Yes thank you!
"Elkar" wrote: See if this is what you're looking for: =(A1-ROUNDDOWN(A1/10,0))*B1*C1*(IF(C1=3,0.8,1)) HTH, Elkar "dj479794" wrote: (Excel 2003) Pricing Scenerio: Unit = $1,000 1 Unit also = 1 Year subscription Can buy multiple years and/or multiple Units for the same year. Think of it as dowloading music. I can buy the right to listen to a song for a year, or that same song for two years. Or I can buy multiple songs. Each can have its own length of time. [A1] contains the number of units they want priced [B1] contains the unit value [C1] contains the number of years [D1] would contain the outbut Pricing Rule#1 Every 10 Units Get One Free (Pertains to cell [A1]) Pricing Rule#2 If a unit is purchased for 3 Years instead of one or two, they gets 20% Discount Can you please help me setup the formulas? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pricing | Excel Discussion (Misc queries) | |||
| Pricing for Inventory | Excel Discussion (Misc queries) | |||
| Retail Pricing | Excel Discussion (Misc queries) | |||
| Old to New Pricing | Excel Worksheet Functions | |||
| How can I enter a value and obtain an average based upon tiers. | Excel Discussion (Misc queries) | |||
Linear Mode
