How many sales people do I need - "multiple of" question

[joshbarocas]

Hi,
I'm developing a spreadsheet but am having trouble determining the most efficient way to set it up. The question is: each salesperson can cover 5 accounts and there are 5,000 accounts, so I need to be able to answer the question "for [x] accounts, how many sales people do I need?" I'd like to be able to set up the spreadsheet such that in column A I enter the number of accounts (1-5000, by 1s) and then in column B essentially be able to say "for every 20 accounts, add 1 to the number of salespeople needed" as shown below. Any help would be appreciated.

A B
1 1
2 1
3 1
4 1
5 1
6 2
7 2
8 2
9 2
10 2
11 3
and so on

[ChemistB]

In B, = INT(A1/5)+1
Does that work for you?

[joshbarocas]

That worked! Thanks so much for the quick and very simple solution!

[Cutter]

@ joshbarocas

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.