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 =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

excel
Formulas and Functions

3 Replies

  • JMB17's avatar
    JMB17
    Bronze Contributor
    Jul 29, 2020

    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}))