Ratios with excel solver
arspiffyblue;
What are you trying to accomplish. Are you trying to verify if the ratio is
correct? Are you trying to adjust the total to match the ratio? Are you
trying to determine the days production ratio? I'm an idjut. Sorry. What
purpose does the solver serve?
I found something called solvsamp.xls on my hardrive. I would suggest you
search for this. It seems to be of interest to what you are trying to do. If
you can give more detail, you might not need this if you write your functions
and formulas correct.
God Bless
Frank Pytel
"arspiffyblue" wrote:
In excel solver (2003) how do you enter a ratio? I assume it would require
entering an inequality, but I don't really know how this would work.
What I am trying to do:
Production of item A and item B must have between a 5:1 to 10:1 ratio.
(between 5-10 of product A for every product B)
|