I'm trying to create a commission tracking spreadsheet.
I need to be able to take the total commission amount and spread it evenly over a set number of months. I also need the formula to start the commission in the month it is effective. Attached is an example- column F is the number of cells that the total needs to be distributed over.sample commission spreadsheet.xlsx
What would a few sample answers look like?
Does it always start in Jan 14?
What would go in Amount Paid?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Try this in K3:Formula:
Please Login or Register to view this content.
Please add reputation by clicking on the * if I have helped.
Please mark the thread SOLVED if your issue has been resolved.
Thanks, Glenn.
Thank you gak67!! That worked perfectly!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks