Increment

[Guest]

for a drawing: for every three X, 1 ticket is received. How do I set up a
formula to recognize increments

 

[Pete_UK]

Can you post a bit more description on this?

Pete

 

[Guest]

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

 

[David Biddulph]

=INT(A1/3)
--
David Biddulph

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

 

[Guest]

That was simple. Thank you. That was very helpful.