Hey guys, here's my little riddle that I'm trying to solve..
A restaurant gets "x amount" of tips for the night.
The TOTAL of "tips for the night" gets split 70 / 30. (Waiters / Kitchen)
The staff working as the "Waiter" role get 70% of the total.
The staff working as the "Kitchen" get 30% of the total.
------
So far, I have this worked out this in my spreadsheet (refer to upload)
Firstly, the formula of splitting the amount of "TOTAL tips for the night" between Waiters and Kitchen is straight-forward.
Secondly, the formula of finding out how much each of the staff members from the Waiters vs Kitchen is also fine.
- Total Tips of Waiters (=C8*0.7)
- Total Tips for each Waiter staff member (=C10/D7)
- Total Tips for Kitchen (C8*0.3)
- Total Tips for each Kitchen staff member (=C14/G7)
(Refer to screenshot)
// However, there are shifts where the owner of the restaurant also works as a waiter, alongside the waiters.
She's selflessly decided to give away all of her tips and split them 50/50 between the waiters and kitchen. \\
Aim of the excel spreadsheet (Here's the tricky part)
I want the checkbox that indicates whether or not the owner of the restaurant is working that night (so far turns cell green to show that's checked, refer to photo)
to automatically adjust the Totals for both categories and their sums (Waiters + individual member / Kitchen + individual member)
WHEN we know that the owner's tips get allocated 50/50 between the Waiters and Kitchen.
When the box is ticked (it means, she's working --> totals get updated and include her 50/50 tips share), when the box is unchecked it just splits it, as explained 70/30 rule.
Thank you kindly!
Martin.
A restaurant gets "x amount" of tips for the night.
The TOTAL of "tips for the night" gets split 70 / 30. (Waiters / Kitchen)
The staff working as the "Waiter" role get 70% of the total.
The staff working as the "Kitchen" get 30% of the total.
------
So far, I have this worked out this in my spreadsheet (refer to upload)
Firstly, the formula of splitting the amount of "TOTAL tips for the night" between Waiters and Kitchen is straight-forward.
Secondly, the formula of finding out how much each of the staff members from the Waiters vs Kitchen is also fine.
- Total Tips of Waiters (=C8*0.7)
- Total Tips for each Waiter staff member (=C10/D7)
- Total Tips for Kitchen (C8*0.3)
- Total Tips for each Kitchen staff member (=C14/G7)
(Refer to screenshot)
// However, there are shifts where the owner of the restaurant also works as a waiter, alongside the waiters.
She's selflessly decided to give away all of her tips and split them 50/50 between the waiters and kitchen. \\
Aim of the excel spreadsheet (Here's the tricky part)
I want the checkbox that indicates whether or not the owner of the restaurant is working that night (so far turns cell green to show that's checked, refer to photo)
to automatically adjust the Totals for both categories and their sums (Waiters + individual member / Kitchen + individual member)
WHEN we know that the owner's tips get allocated 50/50 between the Waiters and Kitchen.
When the box is ticked (it means, she's working --> totals get updated and include her 50/50 tips share), when the box is unchecked it just splits it, as explained 70/30 rule.
Thank you kindly!
Martin.