Forum Discussion
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.
| User | Category | Achievement | Bonus |
| John | A | 65% | 10% |
| John | B | 80% | 0 |
| John | C | 120% | 0 |
| John | D | 68% | 10% |
| John | E | 120% | 0 |
| Jack | A | 68% | 10% |
| Jack | B | 54% | 0 |
| Jack | C | 130% | 0% |
| Jack | D | 65% | 10% |
| Jack | E | 120% | 0% |
- =(C2>=0.6)*(C2<=0.69)*(COUNTIFS(A:A,A2,B:B,"<>E",C:C,">=1.2")>=1)*10%
- Thanks ! Could you explain the formula ? why do we use *
