Forum Discussion

grabofit's avatar
grabofit
Copper Contributor
Jul 28, 2020

Tiered Pricing for Product

Hi, so for my Software i charge prices per User. It is a tired pricing model. 0-50 User = 3,50€ per User 51-250     = 3,00€  251-500   = 2,50€ 501-1000 = 2,00€ 1001-2000 = 1,50€ I tried =S...
excel
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jul 29, 2020

grabofit 

That could be

=LOOKUP(F2, {0,51,251,501,1001},{3.5,3,2.5,2,1.5})