Forum Discussion
Salary cut calculation
Dalia,
It's better to create helper range with parameters
as in the right site of this screenshot. Actually it could be at any place within workbook. Formula in B1 could be
=SUMPRODUCT((($F$2:$F$6-$E$2:$E$6)*($F$2:$F$6-A1<0)+(A1>$E$2:$E$6)*(A1<$F$2:$F$6)*(A1-$E$2:$E$6))*$G$2:$G$6)drag it down.
SergeiBaklan thank you for your answer once again! I am still a bit confused because of this.
What will be salary cut for 200.000 USD salary? Salary cut is applied to amount equal or higher than 200.000 USD.
If I understand it correct for 175.000 USD the cut would be calculated (25.000 USD*20%), or as you write:
But what do I do when the salary is equal to threshold?
I really appreciate your answer! Thank you once again!
Sorry, I'm not familiar with these rules, could you please give entire picture? Formula depends on this. First question was about 30% from the top of 200K. Now it looks like 20% from the top of 150K till 200K PLUS 20% from above 200K. Does that mean 0% from any sum below 150K?
- Sorry, for not explaining the whole picture at once. It is 15% from the top of 100K, and 10 % from the top of 50K.
Thank you so much for your time!
Best regards,
Dalia