Need help with formula to calculate the order quantity of specific food menu items for a catering business based on the number of customers to cater to. Ie. If 15 people to cater and menu includes 4 food items, I need a way to divide the 4 food items by 15 but allow only integral numbers. Ie. not 3.75. The sume of the 4 food items would need to equal to the total people since 1 food item per person. Please Help!
Solved by F. J. in 18 mins