This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi everyone,
I’m struggling to nest an IF formula that would apply a sales commission % to any other agents that make a sale.
Current Formula:
IF({Agent}=“Me”, {Agent}*.24,
IF({Agent}="(Help)", {Agent}*.20,
IF({Agent}=Blank(), 0,"")))
For the Hel...
@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.
If “I’m”={Agent}, then 24% * {G...