I need to adjust rows of values based on a percentage against fixed values on my recipe calculator.

I’ve tried the Ai route and it’s helped, but I can’t quite nail this. I’m struggling with the formulas to execute. Excuse poor terminology, this is not my field of expertise.

I’m writing a recipe calculator with the following columns- ingredients (C), grams (D), percentage of ingredient of total recipe (E), sugar % (F), fat % (G), protein % (H), carbs % (I), sodium % (J) and calories (K).

The ingredients and nutritional % relating to each ingredient is populated via a dropdown list pulled from a table on another worksheet in the same work book.

My goal is to have 20 rows of ingredients.
5 rows (rows 3-7) will have fixed weight (grams) values that don’t change as I make adjustments.
The remaining 15 rows (rows 8-22), I would like to adjust the grams required in the 15 rows to achieve the % result I need of the nutritional value I determine.

The bottom of the table will have a total % of each nutritional value that I want to be able to adjust. M

For example-
1000g ice cream recipe requires 22% sugar

Row 3 - 476g Cream = 2.6% sugar
Row 4 - 204g Milk = 4.8% sugar
Row 5 - 3g Vanilla Bean = 0% sugar
Row 6 - 149g Egg Yolk = 0.2% sugar

Row 8 - 125g Caster Sugar = 100% sugar
Row 9 - 43g Glucose = 80% sugar

This recipe = 31.27% sugar.

I’d like to enter the % value at the bottom of the table, to change the weight of ingredients in rows 8-22.

To further explain, in this example, i want the added sugar (caster sugar & glucose) to update their weights to calculate the final percentage as required.

I would also like to do this with fat as well in the future.