Good day,
Hoping someone can assist.
Backstory:
Some agents make a bit more than others since they're on a new contract. Different ranges of products give different amounts of commissions.
Example:
Lucy sells Product A. She gets $5 commission from it.
Sally sells Product A. She gets $10 commission from it since she's on the new contract.
Lucy sells Product K. She gets $10 commission from it since it's in the next tier of products.
Sally sells Product K. She gets $15 commission from it, again, new contract but on the next tier of products.
I don't mind keeping the list of products and agents for it to check against on another sheet.
Bookmarks