I am trying to calculate a weighted average where the final answer is known, but the multiplier is not.
So I want to know is, if I have a formula such as $30x + 40.3y + 27.8z = 55$, where $x$, $y$ & $z$ will always add to 100%, what are the possible values of $x$, $y$, & $z$. Is there a simple way to do this in excel, or something similar? I would like something that would tell me all the possible combinations of $x$, $y$, and $z$.
Thanks!