number of lets say for example Drinks that could be made from a certain number of items

Hi! I am pretty new to excel, and I am trying to figure out how the total number of lets say for example Drinks that could be made from a certain number of items if that makes sense at all lol.

Lets say it takes 1 apple 2 oranges 2 lemons 1 strawberry would equal 1 drink

So, if I had (39 apple 47 oranges 33 lemons 80 strawberry) I would like to display in a cell the total amount of drinks that could be made. Based on the amount of supply.

I saw this forum, and figured I would ask while I google search to see if I can figure it out. It's not super important just another thing I'm trying to figure out. If could even point me in the right direction that would be cool.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

I did it for you as you are new.Please read the forum rules you seem to have missed. Thanks

Hint: divide available stock (39/47/33/80) by requirement for 1 drink (1/2/2/1) then take smallest from result.
In this case 16.

A yellow box at the top of the page contains important hint for you. Once you prepare a sample file and fill your data it will be much easier to answer.


For such a sample file (I prepared for you - this time only) one could use array formula *:

Formula:

Please Login or Register  to view this content.

*) ...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.