i'm trying to find a formula for calculating a bonus system.
input:
3 months aug - sept - okt
3 amounts possible: 15 - 30 - 60
15€ is for every sales they make, as from the first, if target is reached for that month
30€ is for every sales they make, as from the first, if target is reached for 2 following months. The third month is 0 if under target or 15 if target is reached.
60€ is for every sales the make, as from the first, if target is reached for 3 following months
Is this possible?
Example is attach
thx,
Jelle
Bookmarks