| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Increment
for a drawing: for every three X, 1 ticket is received. How do I set up a
formula to recognize increments |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to increment the date | Excel Discussion (Misc queries) | |||
| increment a value by 1 | New Users to Excel | |||
| How do I increment a formula? | Excel Worksheet Functions | |||
| Increment dates | Excel Discussion (Misc queries) | |||
| need to increment value | Excel Discussion (Misc queries) | |||
Linear Mode
