Hi

With the number of clients in A1
B1 = ROUNDUP(A1/5,0) for Licensed Staff
C1 = ROUNDUP(A1/8,0) for Assistants

--
Regards
Roger Govier

cardingtr wrote:
I'm working on a staffing grid to determine the number of staff needed
depending on the number of clients.

Licensed staff = 1:5 ratio
Assistant = 1:8 ratio

What is the formula so if I enter the number of clients it gives me
two separate values (one for Licenced, 1 for assistant)into two
separate cells.

Simple to do but I'm new to this.