Thread: formula needed
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default 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.