Calculating bonus with multiple conditions

[wmfw2360]

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%

[#2]

=(C2>=0.6)*(C2<=0.69)*(COUNTIFS(A:A,A2,B:B,"<>E",C:C,">=1.2")>=1)*10%

[#3]

Thanks ! Could you explain the formula ? why do we use *

[#4]

@wmfw2360 

The formulas in (...) returns True=1 or False=0 

 (Condition_1)*(Condition_2)*...*(Condition_n)*(Result)

It returns 1*1*...*Result=Result when all conditions are Ture, otherwise 0;

Similar to

If ( AND(Condition_1, Condition_2, ..., Condition_n), Result_If_All_True )