Assistance With Excel Spreadsheet Formulas

I need assistance with a Excel Spreadsheet. Spreadsheet is available at <[login to view URL]> Each employee is paid a monthly commission based on Total Fees and Non-Fees (Cell E29). There are seven threshold limits, which accumulate month to month, which means that until an employees reaches 200,000 year to date fees (Cell E30) they are paid the commission corresponding to the current scale (cells Q3 - Q9 correspond to Scales in cells G3-H4 to G9-H10. Once the employee exceeds the threshhold, they are paid a different rate. If in the course of the month the scale is crossed, they are paid a commission on the monthly fees up to the threshold, and then a commission on the remaining at the increased rate. It could be possible that numerous scales be crossed in the course of a month, which complicates matters. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform Win 2000SP4 and XP Pro and Home