Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula needed
In G40 I have days worked. In H40 I have applications taken. In G16 I need
to know how many underwriters I need. We figure 1 underwriter can handle 5 loans a day. I can't seem to make the number jump to 2 for more than 5 loans a day. As a result I haven't even started on making it go to 3, 4, 5, etc. I only need the formula to go up to 10 underwriters needed. Again, thank you in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula needed
How about:
=Roundup(H40/G40/5,0) "Dave O." wrote: In G40 I have days worked. In H40 I have applications taken. In G16 I need to know how many underwriters I need. We figure 1 underwriter can handle 5 loans a day. I can't seem to make the number jump to 2 for more than 5 loans a day. As a result I haven't even started on making it go to 3, 4, 5, etc. I only need the formula to go up to 10 underwriters needed. Again, thank you in advance. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula needed
=ROUNDUP(H40/G40/5,0)
-- --- HTH Bob (change the xxxx to gmail if mailing direct) "Dave O." wrote in message ... In G40 I have days worked. In H40 I have applications taken. In G16 I need to know how many underwriters I need. We figure 1 underwriter can handle 5 loans a day. I can't seem to make the number jump to 2 for more than 5 loans a day. As a result I haven't even started on making it go to 3, 4, 5, etc. I only need the formula to go up to 10 underwriters needed. Again, thank you in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
IF-THEN Formula help needed | Excel Worksheet Functions | |||
Formula needed | Excel Worksheet Functions | |||
continuous sum formula needed | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions |