Hello everyone,
I use EXCEL for some day-to-day jobs, and in most cases, I can solve problems that arise, but finding a solution to the following problem is beyond my humble abilities: combining in a single formula the two cases described below.
Some workers, due to sick leave, have their wages reduced to two thirds that will be paid by the Social Security system.
In the first case, whether working 30 or 15 days, workers will receive exactly one third of their salary without changes, because the value of two thirds of their total salary is over the 635 wage (minimum wage)
| Total Salary | Days worked | 2/3 Salary | Used Formula |
| A | B | C |
1 | 1500 | 30 | 1000 | C1=(A1/3*2)/30*B1 |
2 | 1500 | 15 | 500 | C2=(A2/3*2)/30*B2 |
In the second case, whether working 30 or 15 days, workers will receive a 635 wage, because the value of two thirds of their total salary is less than the 635 wage (minimum wage)
| Total Salary | Days worked | 2/3 Salary |
|
| A | B | C | C4=IF(((A4/3*2)/30*B4)<=635,635) |
4 | 750 | 30 | (500) 635 | |
5 | 750 | 15 | (250) 635 | C5=IF(((A5/3*2)/30*B5)<=635,635) |
If you have a solution that can help me to solve this problem, it will be extremely and thankfully appreciated.
Thank you.
