Tiered Pricing for Product

[grabofit]

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 =SUMPRODUCT(--(F2>{0,50,250,500,1000,2000}),--(F2-{0,50,250,500,1000,2000}),{3.5,3.5,-0.5,-0.5,-0,5,-0,5})
But Excel doesnt recognize it as a formula

[#2]

Your last array is not the same size as the others. It appears you have commas where you intended decimals?

I think excel is treating this as eight elements versus six.
{3.5,3.5,-0.5,-0.5,-0,5,-0,5})

Maybe this is what you are intending?

=SUMPRODUCT(--(F2>{0,50,250,500,1000}),(F2-{0,50,250,500,1000}),({3.5,-0.5,-0.5,-0.5,-0.5}))

[#3]

@grabofit 

That could be

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

[#4]

@Sergei Baklan