Forum Discussion

arobinson's avatar
arobinson
Frequent Visitor
4 years ago

IF Statement

I am working on a commission sheet for my team. 

 

Criteria for this commission is if Gross Margin is greater than 25% and over all HCP count is greater than 8 the Tier commission is 20%. At the same time, if the same gross margin is expected but more than 25 HCPs the tier commission should be 25% for that line. 

 

I have included a photo below to help. 

 

 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hello,

     

    try:

     

    Commission = SWITCH(

    TRUE(),

    [Gross Margin] > 0.25 && [HCP Count] > 25, 0.25,
    [Gross Margin] > 0.25 && [HCP Count] > 8, 0.2,

    BLANK()

    )

     

     

    If this solved your problem, please mark it as the solution, so others can find it ğŸ™‚