•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
Tagged with
#cloud-based spreadsheet applications
#AI formula generation techniques
#Excel alternatives for data analysis
#formula generator
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#real-time data collaboration
#financial modeling with spreadsheets
#real-time collaboration
#Excel alternatives
#tips
#work period
#formula
#dollar amount
#distribution
#percentage
#total amount
#worked