Pricing Tiers Help

[Guest]

(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!

 

[Guest]

See if this is what you're looking for:

=(A1-ROUNDDOWN(A1/10,0))*B1*C1*(IF(C1>=3,0.8,1))

HTH,
Elkar

 

[Guest]

Yes thank you!

See if this is what you're looking for:

=(A1-ROUNDDOWN(A1/10,0))*B1*C1*(IF(C1>=3,0.8,1))

HTH,
Elkar

(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!