Using Calc to budget a family meal out — how much is Golden Corral for adults?
by david miller -
Number of replies: 0
Hello everyone, I am working through the Calc units and using a real example to practise: a family meal out. I built a small monthly budget calculator sheet with lunch and dinner prices for adults, seniors and kids, so I can compare the total cost before we visit a restaurant. Golden Corral is my example because its buffet prices vary by location and by meal — lunch is around $11.99-$14.99 and dinner around $16.99-$19.99, with lower prices for seniors and kids and under-3s free with a paying adult. If you are planning the same kind of family outing, how much is golden corral for adults has the current lunch, dinner, senior and kids prices in one place. Has anyone else used Calc for a family budget like this? I would like tips on using SUM and simple IF formulas to work out the total for different group sizes.