Each participants gets X numbers of tickets. The number of tickets can change dynamically by day. I need help with the formula to fetch the ticket numbers each participants get.

Right now the columns for Ticket numbers are:

=IF(B2 > 0, D1 1,D1)

=C2 B2

This isn't quite right for obvious reasons.

Example: