Dividing by unknown to get a number
 

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.


--
bundyloco
------------------------------------------------------------------------
bundyloco's Profile: http://www.excelforum.com/member.php...o&userid=23386
View this thread: http://www.excelforum.com/showthread...hreadid=395650

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

"bundyloco" wrote
in message ...

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.


--
bundyloco
------------------------------------------------------------------------
bundyloco's Profile:
http://www.excelforum.com/member.php...o&userid=23386
View this thread: http://www.excelforum.com/showthread...hreadid=395650

bundyloco Wrote:
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.

If you want, you can put "700" (without the quotes or any other number
since you said this is arbitrary) in Cell A1 and the total number of
items that you would like to move in Cell B1 (in your example, this is
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.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=395650

intrigued by the question
i thought if
5000/x=700-by cross multiplication
then x=5000/700
it may give fraction 7.142
appoint 8 people


bundyloco wrote in
message ...

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.


--
bundyloco
------------------------------------------------------------------------
bundyloco's Profile:
http://www.excelforum.com/member.php...o&userid=23386
View this thread: http://www.excelforum.com/showthread...hreadid=395650

=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 :-)
------------------------------*------------------------------*----------------

"bundyloco" wrote
in message ...

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.


--
bundyloco
------------------------------------------------------------------------
bundyloco's Profile:
http://www.excelforum.com/member.php...o&userid=23386
View this thread: http://www.excelforum.com/showthread...hreadid=395650

Do'h...thanks everyone, I knew I was making this way too difficult!


--
bundyloco
------------------------------------------------------------------------
bundyloco's Profile: http://www.excelforum.com/member.php...o&userid=23386
View this thread: http://www.excelforum.com/showthread...hreadid=395650