The project here is to SET UP FORMULAS in an Excel worksheet to calculate commission Total and Sales Total.
The data structure is fixed but the volume changes every time. The formulas must be able to calculate the cumulative commissions and sales for each individual that appears under Staff Name. Rules for each type of staff are different so the formulas must be configured separately.
A youtube video has been included to explain the goals and examples, which have been also included in the attached Excel file as well as some sample data.
If macros must be enabled to achieve the goals, please communicate to me AHEAD OF TIME!
Project winner is welcome to format the non-data area to make the presentation better!
[login to view URL]
19 freelancers κάνουν προσφορές κατά μέσο όρο $85 για αυτή τη δουλειά
Hello Sir i already see your explanation on youtube and i can do build your calculator like u need Sir please give me this job and im able to start working today Thank You Sincerely Galih AP
i can do this. i have good command over Ms excel especially pivot table, charts, advance formulas, formatting, macro etc. Please review my profile and inbox [login to view URL]
Hi concerned I can develop your excel sheet as I have relevant experience and can get the work done quickly. All payments will be when you will satisfy from my work. Hope to hear from you. Thanks!
hello. i am Farhan Haidar i do this work . sir you can trust on me and give me this project i have complete this project in 4 days so you share the detail i also do this project mvdl e-commerce pvt ltd in delhi