IFS Multiples with Multiplication of Values

[jorge37]

Hello, 

I am creating an Appsheet to calculate bonuses. Until then, my IF below is correct:

IFS([Positions]="Analyst", [Your Salary] * 1.5,
[Positions]="Coordinator", [Your Salary] * 2,
[Jobs]="Manager", [Your Salary] * 2.5)

After finishing the first set of IF that is correct. I need the upcoming date to have a count along with these IFs.

Example of what I need and am creating:

IFS([Positions]="Analyst", [Your Salary] * 1.5,
[Positions]="Coordinator", [Your Salary] * 2,
[Positions]="Manager", [Your Salary] * 2.5) AND [FIELD_DATA]=01/01/2023 to 01/31/2023, * 12,[FIELD_DATA]=02/01/2023 to 02/28/2023 , * 11,[FIELD_DATA]=03/01/2023 to 02/31/2023, * 10.

Can you imagine something like that?

Thank you!

[Denny774]

Hey,

maybe something like this?

IFS([Positions]="Analyst", [Your Salary] * 1.5,
[Positions]="Coordinator", [Your Salary] * 2,
[Positions]="Manager", [Your Salary] * 2.5) * (13 - MONTH([FIELD_DATA]))

😆

[jorge37]

Thanks for the response Denny.

Almost that!

What I need is for it to be a fractal formula.

Example: 1/Jan/2023 to 15/01/2023 the salary is full (12/12). on 16/01/ to 01/Feb/2023 if it is entered one day in the field, the value of the salary he will receive is divided by (11/12). And so it goes down until December/2023, where the bonus he will get is 1/12. 12 being the full value.

Imagine that today is 12/31/2023. If the employee starts before January 15, 2023, he will receive another bonus salary.
For each month that passes on the 15th, He will withdraw 1/12 of this bonus salary.