Calculation Change

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.

Thank you

## Deliverables

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.

Skills: Engineering, Microsoft, Microsoft Access, MySQL, PHP, Project Management, Software Architecture, Software Testing, Windows Desktop

See more: how to get an agent, osa, check check spreadsheet, microsoft access check, can someone referrals, backside, need commission agent, calculation php form, windows agent, commission database access, access database commission, commission access database, access calculation, formulas spreadsheet, access commission database, calculation access, access formulas, check box php form database, spreadsheet formulas, cell sale, pool database, will paid change, work performed spreadsheet, spreadsheet commission, change 2008

About the Employer:
( 3 reviews ) United States

Project ID: #3901285

2 freelancers are bidding on average $11 for this job


See private message.

$11.05 USD in 3 days
(351 Reviews)

See private message.

$12.75 USD in 3 days
(5 Reviews)

See private message.

$8.5 USD in 3 days
(1 Review)