1 item per every 75

Question

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.&nbsp;

riny_van_eekelen · Answer

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

vvelezv · Answer

Riny_van_Eekelenexample:&nbsp; 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.&nbsp;

hansvogelaar · Answer

vvelezv&nbsp;
If you need one waiter for every 75 persons:
&nbsp;
=ROUNDUP(number_of_people/75, 0)
&nbsp;

Forum Discussion

1 item per every 75

3 Replies

Resources