Calculating bonus with multiple conditions
I need help with calculating bonus based on the below :-
If user reaches 120% in one category except E, user will get 10% bonus in another category which reached 60%-69%
The bonus column is my desired result.
UserCategoryAchievementBonusJohnA65%10%JohnB80%0JohnC120%0JohnD68%10%JohnE120%0JackA68%10%JackB54%0JackC130%0%JackD65%10%JackE120%0%
I need help with calculating bonus based on the below :- If user reaches 120% in one category except E, user will get 10% bonus in another category which reached 60%-69% The bonus column is my desired result. UserCategoryAchievementBonusJohnA65%10%JohnB80%0JohnC120%0JohnD68%10%JohnE120%0JackA68%10%JackB54%0JackC130%0%JackD65%10%JackE120%0% Read More