May 24, 2019 01:33 PM
Hi everyone,
I’m struggling to nest an IF formula that would apply a sales commission % to any other agents that make a sale.
IF({Agent}=“Me”, {Agent}*.24,
IF({Agent}="(Help)", {Agent}*.20,
IF({Agent}=Blank(), 0,"")))
For the Help portion, I currently want it to show that if any Agent in future were to make a sale, then the commission % would be applied to them, regardless of who they are.
Solved! Go to Solution.
May 24, 2019 05:07 PM
Does this apply the proper logic?
IF(NOT({Agent}),
0,
{Grs.Sale} * SWITCH(
{Agent},
"Me", .24,
"Mgr", .3,
.2
)
If there’s no agent listed, the value is zero. If there’s an agent, then multiply the {Grs.Sale}
value by a percentage that depends on who the agent is. If it’s “Me”, it’s 24%. If it’s “Mgr”, it’s 30%. If it’s anyone else, it’s 20%
May 24, 2019 02:10 PM
May 24, 2019 02:42 PM
@JonathanBowen thank you for the reply.
It didn’t quite work for me.
Ideally, I’m looking for a way to calculate the 20% commission for whomever I name as an {AGENT} for future sales - but until then, leaving it blank.
I know that an easier way would be to keep a running list of Agents and simply link the {AGENT} sheet to that field but the layout I current have auto-calculates after manually entering AR, AP, and AGENT.
May 24, 2019 05:07 PM
Does this apply the proper logic?
IF(NOT({Agent}),
0,
{Grs.Sale} * SWITCH(
{Agent},
"Me", .24,
"Mgr", .3,
.2
)
If there’s no agent listed, the value is zero. If there’s an agent, then multiply the {Grs.Sale}
value by a percentage that depends on who the agent is. If it’s “Me”, it’s 24%. If it’s “Mgr”, it’s 30%. If it’s anyone else, it’s 20%
May 24, 2019 05:20 PM
@Justin_Barrett thank you so much! It worked!!!