| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What function to use?
I want to use a function to determine how many bonus tickets I should give
out at the end of each month. One (1) ticket for every three (3) apples sold. For example, here is a table: DATE #APPLES SOLD BONUS TICKETS JAN 1 0 FEB 3 1 MAR 6 2 APR 8 2 MAY 9 3 JUN 12 4 JUL 15 5 PLEASE HELP! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What function to use?
Hi,
You could try this... Say your no of Apples sold start in cell B2 In B3 type =B2/3 And then copy down as far as you need Hoep this helps, Gav. "TRYIN" wrote: I want to use a function to determine how many bonus tickets I should give out at the end of each month. One (1) ticket for every three (3) apples sold. For example, here is a table: DATE #APPLES SOLD BONUS TICKETS JAN 1 0 FEB 3 1 MAR 6 2 APR 8 2 MAY 9 3 JUN 12 4 JUL 15 5 PLEASE HELP! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What function to use?
I'm sorry I forgot to say that the bonus tickets are cumulative by each month.
DATE #APPLES SOLD BONUS TICKETS (cumulative) REP Name jan 2 0 JOHN feb 3 1 JOHN mar 7 3 JOHN apr 5 4 JOHN may 12 8 JOHN jun 14 12 JOHN jul 19 18 JOHN aug 21 25 JOHN sep 1 25 JOHN "Gav123" wrote: Hi, You could try this... Say your no of Apples sold start in cell B2 In B3 type =B2/3 And then copy down as far as you need Hoep this helps, Gav. "TRYIN" wrote: I want to use a function to determine how many bonus tickets I should give out at the end of each month. One (1) ticket for every three (3) apples sold. For example, here is a table: DATE #APPLES SOLD BONUS TICKETS JAN 1 0 FEB 3 1 MAR 6 2 APR 8 2 MAY 9 3 JUN 12 4 JUL 15 5 PLEASE HELP! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What function to use?
try:
=INT(<number of apples sold/3) -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "TRYIN" wrote in message ... I want to use a function to determine how many bonus tickets I should give out at the end of each month. One (1) ticket for every three (3) apples sold. For example, here is a table: DATE #APPLES SOLD BONUS TICKETS JAN 1 0 FEB 3 1 MAR 6 2 APR 8 2 MAY 9 3 JUN 12 4 JUL 15 5 PLEASE HELP! |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What function to use?
On Jan 4, 8:25*am, TRYIN wrote:
I'm sorry I forgot to say that the bonus tickets are cumulative by each month. DATE * * * * * *#APPLES SOLD * *BONUS TICKETS (cumulative) Jan * * *2 * * * * * * * * * * * * * * *0 * * * * * * * * * * * * * * feb * * 3 * * * * * * * * * * * * * * * 1 * * * * * * * * mar * * 7 * * * * * * * * * * * * * * * 3 * * * * * * * * * * * apr * * 5 * * * * * * * * * * * * * * * 4 * * * * * * * * * may * * 12 * * * * * * * * * * * * * * *8 * * * * * * * * * * jun * * 14 * * * * * * * * * * * * * * *12 * * * * * * * * jul * * 19 * * * * * * * * * * * * * * *18 * * * * * * * * aug * * 21 * * * * * * * * * * * * * * *25 * * * * * * * * sep * * 1 * * * * * * * * * * * * * * * 25 * * * * * * * In C2 and copy down: =C1 + int(B2/3) |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What function to use?
Doh! I meant of course:
=INT(B2/3) and: =C2+INT(C3/3) So much for being able to write formulas without trying them in the spreadsheet! -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Sandy Mann" wrote in message ... With your data in A1:C13 In B2 enter the formula: =INT(A2/3) In B3: =B2+INT(A3/3) and drag down on the fill handle -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "TRYIN" wrote in message ... I'm sorry I forgot to say that the bonus tickets are cumulative by each month. DATE #APPLES SOLD BONUS TICKETS (cumulative) REP Name jan 2 0 JOHN feb 3 1 JOHN mar 7 3 JOHN apr 5 4 JOHN may 12 8 JOHN jun 14 12 JOHN jul 19 18 JOHN aug 21 25 JOHN sep 1 25 JOHN "Gav123" wrote: Hi, You could try this... Say your no of Apples sold start in cell B2 In B3 type =B2/3 And then copy down as far as you need Hoep this helps, Gav. "TRYIN" wrote: I want to use a function to determine how many bonus tickets I should give out at the end of each month. One (1) ticket for every three (3) apples sold. For example, here is a table: DATE #APPLES SOLD BONUS TICKETS JAN 1 0 FEB 3 1 MAR 6 2 APR 8 2 MAY 9 3 JUN 12 4 JUL 15 5 PLEASE HELP! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
| Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions | |||
Linear Mode
