1 item per every 75

New Contributor

Hi, I want a formula that calculate how many employees I need for an event. Example: 1 employee per every 75 people. If I write 70 or 80, or 100... I want it to tell me the total amount of eployees I will need. 

3 Replies

@vvelezv If the respective answers you seek are 0, 1, 1, the that could be like this:



@Riny_van_Eekelenexample:  if I need 1 employee per every 20 people. And the event is 70 people I will need 4 waiters at least. I need a formula that does that. 


If you need one waiter for every 75 persons:


=ROUNDUP(number_of_people/75, 0)