Function to use...

  • Thread starter Thread starter TRYIN
  • Start date Start date
T

TRYIN

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
and the number of bonus tickets are culmulative.
For example, here is a table:


Date ApplesSold #BonusTicket RepName
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
 
=INT(B2/3)

should do it

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Didn't you like the answers that you got to your previous request 39 minutes
ago?

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What function to use? 6
When building a chart Dates are been included that are not in thedate range 1
Changing Sum Range Based on Date Chosen from Drop Down List 1
Copy from sheet1 and sheet2 and append to sheet3 in different format 8
table lookup 5
counting the number of consecutive days 12-17-09 2
use offset function 4
Calculate End Date Using Start Date and No. of Days excluding specific days. 0

Back
Top