# Calculating bonus with multiple conditions

Copper Contributor

# 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%
3 Replies

# Re: Calculating bonus with multiple conditions

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

# Re: Calculating bonus with multiple conditions

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

# Re: Calculating bonus with multiple conditions

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 )``