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.