'Calculating percentages for the month and working time
In the previous Article, I asked you for help in calculating the percentages in a given range, now I need further help
Link to the previous article how to find the percentage between 2 numbers with 2 conditions?
Now I need to calculate the bonus to the employee it consists in the fact that the employee has a bonus paid for each day where the bonus has been earned, but I must have a result in one cell
C17 - Name
C18 - hourly rate
D18,F18,H18,J18,L18,N18,P18,R18,T18,V18 - It has a formula =IFS(D17<90%;0;D17>120%;15%;PRAWDA;D17*37,5%-30%)
E18,G18,I18,K18,M18,O18,Q18,S18,U18,W18 - It has a formula =$C18*D18*(E17*24)
Currently, after adding the amount for each day, cells E18,G18,I18,K18,M18,O18,Q18,S18,U18,W18 It is equal 58,08 zł
And if we add up all the norms from line 18 and divide them into the number of days, in this case there are 10 of them, we get 4,450125% where, after multiplying the working time "67:02:34" by the hourly rate and the percentage obtained earlier, we get the sum of 59.67 zł
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
Solution | Source |
---|