Forum Discussion
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 whole salary.
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?
Abiola1 thank you for answer.
It looks like this reduction is for the whole initial salary, not only the amount exceeding the threashold of 200. Maybe I was not clear enough: the salary reduction is not for the whole salary, but only for the amount equal or exceeding 200. For example for 250 salary the reduction is applied only for 50 USD.
But what happens to the salary which is exactly 200.000 USD? How the cut should be calculated in this case?
To calculate a 30% salary cut on amounts exceeding USD 200,000 for a USD 210,000 salary, subtract 200,000 from 210,000 to get 10,000. Then, apply the 30% cut to 10,000, which is 3,000. Subtract this from 210,000, resulting in a final salary of 207,000. For more complex calculations, consider using a UIF calculator.
