LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
bundyloco
 
Posts: n/a
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need number of Saturdays and number of Sundays between 2 dates Class316 Excel Worksheet Functions 1 June 10th 05 02:47 AM
making a number be text Fredrated Excel Worksheet Functions 2 June 1st 05 02:37 AM
How to Calculate an unknown number? Beau Excel Worksheet Functions 1 May 28th 05 01:20 AM
New installed Excel2003 keeps dividing any number entered in any . Jan E. Sørensen Excel Discussion (Misc queries) 3 February 16th 05 02:29 PM
Convert week number into calendar month? WickyWick Excel Worksheet Functions 2 November 9th 04 09:01 PM


All times are GMT +1. The time now is 10:31 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"