Can this be solved? or am i dealing with circular reasoning?

[Nietz]

Hey all, short time lurker first time poster.

i have been asked to create a quick spreadsheet that calculates the required mixing weight of two ingredients based on moisture content(%).

Knowns:
Total Finished Weight (kgs - assuming no loss)
Total moisture content (% - again assuming no loss)
Ingredient 1 moisture content (%)
Ingredient 2 moisture content (%)

Unknowns:
Weight of ingredient 1 (kgs)
Weight of ingredient 2 (kgs)

Formula assumptions:
Total Finished Weight = sum of ingredient weights
Total Moisture = (ingredient 1 weight * Ingredient 1 moisture) + (ingredient 2 weight * Ingredient 2 moisture)

Everytime i come up with a viable equation it ends up either referencing itself or the unknown weight of the other ingredient. Anyhelp with the equation or on getting excel to calculate in a circular fashion would be greatly appreciated.

Nietz

[Nietz]

Solved!

Had an error in one of my assumptions.