I need to know how to create a formual to understand that for every 3 points,
1 ticket is to be drawn. So if someone get 6 points they would receive 2
tickets, 9 point= 3 tickets, and so on. But also factor in, if less than 3
points=0, more than 3 but less than 5 points=1, and so on.

Thanks for responding


"Pete_UK" wrote:

Can you post a bit more description on this?

Pete

On Nov 8, 10:15 pm, Maria wrote:
for a drawing: for every three X, 1 ticket is received. How do I set up a
formula to recognize increments