IF Statement

[arobinson]

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. 

[Anonymous]

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 🙂