BrighJShane
New Member
- Joined
- Jul 7, 2017
- Messages
- 4
Hi All,
Hope you are having a lovely run up to Christmas!
I am having an issue probably due to lack of experience. I have been coding for a few months and now i am having an issue with dynamic codes.
Essentially, here is my issue:
Column A are people's names.Column B shows their individual meal costs in the hotel's restaurant (i.e. Johns meal is £36, Annie's meal is £56 etc.). Column C shows the room number that individual belongs to (So Annie , john, Marc and Pedro are from room 5, Jacob and Victoria from room 6 etc.). The reason this is important is because dinner costs are added to the overall room bill. Column D shows whether the customer is a hotel guest or not (Simple yes/no).
I want the code to filter column B family by family(alphabetically) and IF column D is YES, dynamically calculate the TOTAL cost of the entire meal cost of that family from column B and if that total is less than 50, a minimum charge of 50 will be applied across the household evenly, meaning if the family has 4 people, each will get 12.50 in the column B for that family. Now, If its over £50, then whatever the amount is will be charged as it stands. This will then loop through each family until the end.
I hit a brick wall with this as i dont know how a dynamic code like that will look like. Any help will be appreciated. Merry christmas!
Hope you are having a lovely run up to Christmas!
I am having an issue probably due to lack of experience. I have been coding for a few months and now i am having an issue with dynamic codes.
Essentially, here is my issue:
Column A are people's names.Column B shows their individual meal costs in the hotel's restaurant (i.e. Johns meal is £36, Annie's meal is £56 etc.). Column C shows the room number that individual belongs to (So Annie , john, Marc and Pedro are from room 5, Jacob and Victoria from room 6 etc.). The reason this is important is because dinner costs are added to the overall room bill. Column D shows whether the customer is a hotel guest or not (Simple yes/no).
I want the code to filter column B family by family(alphabetically) and IF column D is YES, dynamically calculate the TOTAL cost of the entire meal cost of that family from column B and if that total is less than 50, a minimum charge of 50 will be applied across the household evenly, meaning if the family has 4 people, each will get 12.50 in the column B for that family. Now, If its over £50, then whatever the amount is will be charged as it stands. This will then loop through each family until the end.
I hit a brick wall with this as i dont know how a dynamic code like that will look like. Any help will be appreciated. Merry christmas!