Tiered promotion

[drmisha]

Hi!
I'm designing a new promotion and i'm thinking how to determine the quantity for each tier as well as how to determine what tiers i should create?

e.g.

Tier 1 = 1 to 5 units purchase = 2x bonus points
Tier 2 = 6 to 50 units purchase = 5 x bonus points
Tier 3 = 51 units and above = 10 x bonus points

Anyone has any idea how to determine the number of units per tier, as well as the "points" to give out per tier?

Thanks very much in advance!

 

[AlanY]

try this in B1
with units purchased in A1

=LOOKUP(A1,{0;6;51},{2;5;10})

 

[drmisha]

try this in B1
with units purchased in A1

=LOOKUP(A1,{0;6;51},{2;5;10})

Thanks Alan. very helpful for calculating outcome of this promotion...
However, i'm wondering how to do data analytics to determine the tiering as well as the bonus points to be given out before the start of the promotion...?

 

[AlanY]

is this what you're after?

=LOOKUP(A1,{0;6;51},{"Tier 1";"Tier 2";"Tier 3"})