Forum Discussion

Copper Contributor

Jul 19, 2022

1 item per every 75

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...

excel

Formulas and Functions

Riny_van_Eekelen

Platinum Contributor

Jul 19, 2022

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

vvelezv
Copper Contributor
Jul 20, 2022
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.
- HansVogelaar
  MVP
  Jul 20, 2022
  vvelezv
  
  If you need one waiter for every 75 persons:
  
  =ROUNDUP(number_of_people/75, 0)