Currently, our agents get a 28% commission after all referrals and an admin pool has been deducted from the gross commission. These calculations are performed automatically on the backside of our Microsoft Access Form.
I have added in a Cell next to the check box OSA. I need someone to correct the forumlas to allow me to type in a commission amount into that box. Whatever commission amount I type into that box is the commission amount that the agents will be paid based on (no longer will they be paid based on the 28%). It needs to then reflect that in every other calculation in the form and spreadsheet. Including directly below that I can have up to 4 different agents share in the 28% commission by designating them to get up to 100% of the 28%. However, with this change up to 4 agents would now be eligible to receive whatever I put in that box.
Whatever is changed it needs to calculate correctly in every other aspect of the spreadsheet. i just need to be able to change what commission each agent gets instead of them only getting 28% on each sale.
If possible I would like to learn how to do this myself. I would like you to tell me how to do it and me do the work. If that is possible. thank you for your time.
I am very familiar with this database. I created most of it with the exception of the formulas. I have manipulated some of them throughout the course of working with it so it shouldn't be to hard for me.