Forum Discussion
Solved
Salary cut calculation
Hi, how do I calculate salary cut by 30 % only for the salary value which for example is USD 210.000? The cut is to be calculated only for amount equal or exceeding the USD 200.000 value, not for the...
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.
- Thanks, how do I calculate 0,A1?
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!
