Increment
 

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

Increment
 

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

Increment
 

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

Increment
 

=INT(A1/3)
--
David Biddulph

"Maria" wrote in message
...
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

Increment
 

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

"David Biddulph" wrote:

=INT(A1/3)
--
David Biddulph

"Maria" wrote in message
...
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