How to make percentages add up correctly

Hello, I have a chart which auto-calculates how much of each ingredient I need to make a specific mixture. After it auto-calculates that, it also auto-calculates how much of each ingredient I still have remaining, and it then calculates how much more of that specific mixture I can make, with those remaining values of each ingredient, that's where the problem lies, I can't figure some things out, look. 1p.png Take a look at that "possible amount from each remaining", and also look at the "%", in my auto calculations, the "b" ingredient is greater than "a", even though in "%", "a%" is greater than "b%". (a is 54% and b is 22.6% but for some reason a is 39.042 and b is 72.3. Don't know what to do. 2p.png. I'll try to calculate c and d when I know how to calculate a properly

This is probably to do with rounding.

There are instructions at the top of the page explaining how to attach your sample workbook.

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. Tell us what you are trying to do, not how you think it should be done.

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.

(Note: this change is not optional. As you are still new here, I have done it for you today.)

row 13 doesn't look right to me, though it could be that I am not correctly understanding what you are trying to do. I would have expected something like:

1) Figure out how much product could be made from the remaining of each as if it were the limiting ingredient. possible=remaining/% or B13 =B12/B2 copied across
2) Look at the possible remainings and choose the smallest. B14 =MIN(B13:E13)

nah, unfortunately that doesn't work:/ I mean doesn't calculate what I need, but thanks for effort anyway

"Doesn't work" is not going to be of any assistance to your helpers.

To wit, whilst I realise that English may not be your first language, 'please' and 'thank you' are universal courtesies.

the formula from josephteh, put into cell B13, then dragged across, seems to work:

Please Login or Register  to view this content.

Sorry math isn't really my strong suit but, if b is 22.6% and 72.3g, and a is 54% can it be that a is truly 172.75g? Because too me it looks be a bit too much to be an addition of 31.4%

If the math seems confusing, I would suggest thinking of these as "proportionalities" rather. Using B as the limiting ingredient, the proportionality is massB/wt%B=massA/wt%A and solve for massA so massA=massA*massB/wt%B, which, I think, is what the proposed formula is. FWIW, 54*72.3/22.6 correctly evaluates to 172.75.

If you would like an algebra tutorial for solving proportions: https://www.purplemath.com/modules/ratio2.htm