I have a following requirement to calculate incentive for my team that has slab and percentage. The requirement has 4 conditions -
Condition 1: If Resource 1 monthly target < 0, then Resource should get 0 incentive
Condition 2: If Resource 1 monthly target = target, then Resource should get paid 5% on target
Condition 3: If Resource 1 monthly target > target, then Resource should get paid 5% on target + 10% on the balance/difference of target
Condition 4: If Resource 1 monthly target > 2,00,000, then Resource should get paid 5% on target + 10% on the balance/difference of target + 15% on the amount above 2,00,000
The current formula satisfies only upto 3 conditions. Am having a challenge for all 4 conditions -
=IF((H16<0),0,((E16*(5/100))+(H16*(7/100))))
Any help is always welcome
Bookmarks