Splitting the café bill

Groups at a café split the bill evenly and leave a tip. The tip percentage is in G1.

In D2:D8, calculate how much each guest pays: the bill plus the tip is divided by the number of guests and rounded up to whole dollars, so there's definitely enough money.