Forum Discussion
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...
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}))