Multiple variable inputs and outputs table

CakeMaster

New Member
Joined
Aug 26, 2021
Messages
2
Office Version
  1. 365
Platform
  1. Windows
Attached image.

I am attempting to create an input table where I input how many of each cake made, and an output table that calculates # of bags for each ingredient used.

I know how to manually calculated this (Example: Vanilla cake has 300 cakes made, to calculate flour used [(300 cakes * 600 grams of flour)/500 grams per bag] = 360 bags of flour

Unfortunately I don't know the faintest idea where to start, vlookup, sumif, match, index, need to use a macro?? Any insight would be appreciated, not looking for someone to do the work for me, just a place to start would be grand. It would save so much time at work if excel could do this for me instead of myself manually doing it.

Goal: Input how many of each cake made (vanilla, chocolate, cherry) and the output table simultaneously calculates how many bags of each ingredient have been used that day.

P.S. not in the baking industry
 

Attachments

  • CakesInput.PNG
    CakesInput.PNG
    32.3 KB · Views: 28

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Forum statistics

Threads
1,223,884
Messages
6,175,175
Members
452,615
Latest member
bogeys2birdies

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top