Forum Discussion
Solved
Cost estimator for small scale catering
Hello, I need a formula to calculate how much it would cost all up to make a menu item eg, chicken sandwich by looking up each code and multiplying the quantity with its associated unit cost. I have ...
Dear Lousa Dira,
I need to make some ammendments in the previous array formula.
In the mean time, you may use the attached Excel file which contains 2 independent methods of doing the activity. Choose the one you find most appropriate.
Do let me know if any clarification is required.
Vijaykumar Shetye,
Spreadsheet Excellence,
Panaji, Goa, India
Its a pretty long formula but does the job correctly
Hi Zachary,
Thanks so much! I copied the formula and even though it is long, I can follow and it does the trick! All I have to do is update the range whenever I add more items on the list. Thankyou for your time in writing up the formula.
Regards,
Louisa
Thanks so much! I copied the formula and even though it is long, I can follow and it does the trick! All I have to do is update the range whenever I add more items on the list. Thankyou for your time in writing up the formula.
Regards,
Louisa
- You're welcome, hope this saves you lots of time!