Dividing by unknown to get a number

B

bundyloco

I am trying to determine the amount of people it will take to complete a
task. The problem is, I have calculated how big the task will be, but I
would like a function to determine how many people are needed.
For example:

I know 1 person can move 700 items without risk of injury (so I would
like to stay around this number...it's arbitrary). So I would like a
function to calculate how many people it will take to move say 5000
items?
ie 5000/x=700 where x is the number of workers. Does anyone have an
idea of an if statement that could do this. Obvisously, if the number
is less than 700, I would have a default of 1.

Thanks in advance.
 
P

Paul B

bundyloco, with 5000 in A1, =IF(A1<701,1,A1/700) Am I missing something??

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
B

BenjieLop

bundyloco said:
I am trying to determine the amount of people it will take to complete
task. The problem is, I have calculated how big the task will be, but
would like a function to determine how many people are needed.
For example:

I know 1 person can move 700 items without risk of injury (so I woul
like to stay around this number...it's arbitrary). So I would like
function to calculate how many people it will take to move say 500
items?
ie 5000/x=700 where x is the number of workers. Does anyone have a
idea of an if statement that could do this. Obvisously, if the numbe
is less than 700, I would have a default of 1.

Thanks in advance.
Click to expand...

If you want, you can put "700" (without the quotes or any other numbe
since you said this is arbitrary) in Cell A1 and the total number o
items that you would like to move in Cell B1 (in your example, this i
5000).

In Cell C1, enter this formula : =if((B1/A1)<1,1,B1/A1)

Another formula would be : =if(B1<A1,1,B1/A1)

Regards
 
K

Ken Wright

=ROUNDUP(A1/700,0)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :)
------------------------------­------------------------------­----------------
 
Top