Calculator with inputs & outputs in same cells

Hi.

This one is hard to explain but I'd imagine maybe not too hard to do.

In the attached file, I want to allow the user to write either the sodium or salt percentage for each ingredient 1-5, depending on what is listed on the package, and for the "grams" columns to take into account those numbers and calculate an equal number of grams of each ingredient necessary to achieve the salt percentage put in at the top. BUT!, I'd like the user to also be able to adjust the amount of grams of any particular ingredient such where say they want to add 50g of salt, then the MSG and ingts 1-5 would all be adjusted to equal amounts of the remainder, and so on.

I hope this makes sense.

Thanks!

Thanks for the reply! Here is the updated file with instructions.

It would be helpful if you can show how changing 19.08g of MSG to 10g changes 6.05g of Salt to 7.09g.

Yes please!

I just made that number up as a placeholder. I didn't do the actual math.

I'm very sorry. I didn't mean for anyone to bother with the math itself. That I can do. My questions were Excel related questions.

-In fermenting you want at least 2% salt but sometimes more.
-But it is actually the *sodium* that you are looking for.
-The amount of sodium in salt is 38.8%, so it could be more accurately said that you want a minimum of 0.776% sodium in a fermentation.
-Since I like to use different sodium sources, I want to make a calculator that can tell me how much of each I can add to achieve my desired sodium level (salt equivalent).
-But, I sometimes I know I want to add a specific amount of a particular ingredient, so I'd like to input that and have the rest recalculate accordingly.

Hi AliGW, it was perhaps bad form because I know not of Excel form. Sorry about that.

Sorry to all. In an attempt to re-endear myself, please enjoy this Excel-related joke I saw the other day:

Some see the glass as 1/2 full.
Some see the glass as 1/2 empty.
Excel sees the glass as January 1st.

AliGW I again acknowledge that the 'dummy data' was unhelpful. Though my question had to do with the programming of the cells and not the numbers themselves.

You are objectively wrong about the quality of that joke, insofar as such a thing can be objective.

Sean

Here is an updated version of the spreadsheet