0
$\begingroup$

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!

  • 1
    There are an infinite number of combinations of x, y, and z. Are there any other restrictions on your variables?2012-12-07

1 Answers 1