I am the operations manager of a catering company and am designing a few Excel documents that I need help with in reference to If/Then statements.
Ex: If my order is to serve 10- 30 people I need 2 types of pasta at 5oz per person divided equally
If my order is greater than 30 people I need 5oz of pasta per person divided equally over 3 types of pasta
I have several other menus to do the same with, probably no more than 8 total statements to be written.
Please email name, cell# and email and a general idea of pricing. I'm thinking this is about 1 hours worth of work for someone who knows the ins/outs of Excel better than I.