•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to average out tips over a 30 day work period based on,
Im trying to find a formula that takes a dollar amount then disturbed it based on the total amount each person has worked.
Example.
800 dollar total in tips for the month
4 people
24 work days per month
The above part is easy, im having an issue with
What if person A only worked 80% of the month, and person B worked 110% of the month and person C and D worked 100% of the month.
How do I write the formula so that the $800 is distributed based upon the percentage of time they worked,
[link] [comments]
Want to read more?
Check out the full article on the original site