Dividing by unknown to get a number

[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.

[BenjieLop]

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.

[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

"bundyloco" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[R.VENKATARAMAN]

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 <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

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

"bundyloco" <[email protected]> wrote
in message news:[email protected]...
>
> 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]

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

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

"bundyloco" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[R.VENKATARAMAN]

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 <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[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

"bundyloco" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[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

"bundyloco" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[R.VENKATARAMAN]

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 <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

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

"bundyloco" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[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

"bundyloco" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[R.VENKATARAMAN]

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 <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

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

"bundyloco" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

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

"bundyloco" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[R.VENKATARAMAN]

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 <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[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

"bundyloco" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[R.VENKATARAMAN]

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 <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

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

"bundyloco" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[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

"bundyloco" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[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

"bundyloco" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[R.VENKATARAMAN]

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 <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

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

"bundyloco" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

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

"bundyloco" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[R.VENKATARAMAN]

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 <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[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

"bundyloco" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

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

"bundyloco" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[R.VENKATARAMAN]

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 <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[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

"bundyloco" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[R.VENKATARAMAN]

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 <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

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

"bundyloco" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[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

"bundyloco" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[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

"bundyloco" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[R.VENKATARAMAN]

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 <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

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

"bundyloco" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

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

"bundyloco" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[R.VENKATARAMAN]

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 <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[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

"bundyloco" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[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

"bundyloco" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[R.VENKATARAMAN]

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 <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

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

"bundyloco" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[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

"bundyloco" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

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

"bundyloco" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[R.VENKATARAMAN]

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 <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[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

"bundyloco" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[R.VENKATARAMAN]

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 <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

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

"bundyloco" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

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

"bundyloco" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[R.VENKATARAMAN]

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 <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[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

"bundyloco" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

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

"bundyloco" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[R.VENKATARAMAN]

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 <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[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

"bundyloco" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[R.VENKATARAMAN]

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 <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[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

"bundyloco" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

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

"bundyloco" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[R.VENKATARAMAN]

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 <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

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

"bundyloco" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[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

"bundyloco" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>