Forum Discussion
Dalia_Dargyte
Mar 26, 2020Copper Contributor
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...
- Mar 27, 2020
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
Mar 27, 2020Diamond Contributor
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.
Dalia_Dargyte
Mar 30, 2020Copper Contributor
SergeiBaklan thank you so much for your help! It worked great:)
- SergeiBaklanMar 30, 2020Diamond Contributor
Dalia_Dargyte , you are welcome