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