pay fixation

[paramveer]

after match two combination answer increment given to next row mention in excel sheet
thanks in advance

 

[bosco_yip]

In G2, enter formula :

=SUMIFS(chart!C2:C1061,chart!B1:B1060,D2,chart!C1:C1060,E2)

 

[p45cal]

You'll get the same result with:
=ROUND(E2*1.03,-2)
Also note I think there's an error on your chart sheet; cells B839:B869 should be 22 and not 21.
Also note if using the chart sheet that when someone has reached the top pay of their level the next row is usually less pay!

 

[paramveer]

In G2, enter formula :

=SUMIFS(chart!C2:C1061,chart!B1:B1060,D2,chart!C1:C1060,E2)

View attachment 77396

thanks sir for solving my problem

 

[paramveer]

You'll get the same result with:
=ROUND(E2*1.03,-2)
Also note I think there's an error on your chart sheet; cells B839:B869 should be 22 and not 21.
Also note if using the chart sheet that when someone has reached the top pay of their level the next row is usually less pay!

thanks i dont think this