Forum Discussion

Copper Contributor

Aug 26, 2024

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 m...

excel

Formulas and Functions

XXplore

Brass Contributor

Aug 26, 2024

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

wmfw2360
Copper Contributor
Aug 26, 2024
Thanks ! Could you explain the formula ? why do we use *
- XXplore
  Brass Contributor
  Aug 27, 2024
  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 )