Hello everyone.
I'm in need of a formula for my Real Estate Office. The purpose of this formula would be to calculate an agent's split based on certain criteria.
For example...
John has a 75/25 split
Maria has a 60/40 split
John brings in a $20,550 commission
Maria brings in a $10,420 commission
I'm basically looking for a formula (based on the person's name) that when Maria brings in a commission, apply 60% and if John brings it in, apply 75%. See attachment for reference.
Thanks for your help
Bookmarks