Forum Discussion
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 sa...
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 🙂