Jul 28 2020 11:51 PM
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
Jul 29 2020 12:38 AM - edited Jul 29 2020 12:47 AM
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}))
Jul 29 2020 09:57 AM