Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() 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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need number of Saturdays and number of Sundays between 2 dates | Excel Worksheet Functions | |||
making a number be text | Excel Worksheet Functions | |||
How to Calculate an unknown number? | Excel Worksheet Functions | |||
New installed Excel2003 keeps dividing any number entered in any . | Excel Discussion (Misc queries) | |||
Convert week number into calendar month? | Excel Worksheet Functions |