View Single Post
  #1   Report Post  
cardingtr
 
Posts: n/a
Default Working on Staffing grid


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.


--
cardingtr
------------------------------------------------------------------------
cardingtr's Profile: http://www.excelforum.com/member.php...o&userid=27027
View this thread: http://www.excelforum.com/showthread...hreadid=466573