View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Shann0n
 
Posts: n/a
Default Ratios in Excel Solver

Thanks so much! I had the "B27<=" part, I just wasn't sure how to finish it.
It seems that the answer was just too simple and I wanted to confuse myself
and make it harder than it was!

"Bernard Liengme" wrote:

A constraint apples to the value in a cell.
If you need item-a/item-b to be in the ration 4:1
The in some cell (say D4) enter =x2/x3 where these cell ref to the items
Now make the constraint D4 = 4
Any help?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Shann0n" wrote in message
...
How do I enter a ratio as a constraint in Solver? My ratio is 4:1, do I
simpy put 4:1?