View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Frank Pytel Frank Pytel is offline
external usenet poster
 
Posts: 103
Default 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)