Forum Discussion

Dalia_Dargyte's avatar
Dalia_Dargyte
Copper Contributor
Mar 26, 2020

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...
  • SergeiBaklan's avatar
    SergeiBaklan
    Mar 27, 2020

    Dalia_Dargyte 

    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.

Share

Resources