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.

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.

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.