I am trying to create a spreadsheet to distribute a total tip number. I have multiple different positions that recieve a different percentage of the tips. How can I distribute exactly what my total tips are to these different positions at different positions?
Example: If my bartender makes $100.00, he tips out the barback 1/3 or 33%. My bartender should make double what the barback makes.
I have a total tip column, an hours column, and a distributed tip column which needs to reflect my percentage difference, but still equal my total tip column.
Bookmarks