 SOLVED

Highlighted

# A problem to solve

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 worked2/3 Salary
 Used Formula

A

BC

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.

3 Replies
Highlighted
Best Response confirmed by Joao2295 (New Contributor)
Solution

# Re: A problem to solve

Hi - This may fit your requirement:

=IF(ROUND(A3*0.66666,0)<635,635,ROUND(A3*0.66666,0)/(30/B3)) Highlighted

# Re: A problem to solve

Amazing solution. Elegant and effectiveI would never think of that.

Thank you very much.

Joao

Highlighted

# Re: A problem to solve

Thank you - happy to help.