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! |
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! |
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! |
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! |
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) |
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! |
All times are GMT +1. The time now is 10:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com