Jul 18 2020 06:03 PM
Alright, so I'm trying to calculate a share of profits that goes to different employees during a week. At the end of my week, i have a spreadsheet that adds all the profit every one gets. I have 3 employees that feeds on the same cut, I need to be able to enter their names on the day of the week on which they worked so that they get the cut and the 2 others doesn't. Can anyone help me with that?
Jul 18 2020 06:23 PM
@FRANK_TRIES , A sample file (with confidential info removed) would be helpful to answer your question(s).
Jul 18 2020 06:26 PM
If we were sitting down together and trying to work this out, I'd have to ask a few more questions. I'm pretty sure anybody else would too. So bear with me/us. It will also help if you can post a copy of whatever workbook/spreadsheet you already have as a starter, so we don't have to create something from scratch that has no bearing on your reality.
That said, here are some questions:
You get the idea....