Hi. Here's one way: Your statement...

5< a/b <10

Multiply by 'b'
Trick is to make sure 'b is positive, otherwise the inequality might change.

5*b < a < 10*b

With Solver, it's best not to have a variable on the right-hand side.
I'd would add the two constraints like this.

a - 5*b = 0
10*b - a = 0

Good luck.
--
HTH :)
Dana DeLouis
Windows XP & Excel 2007


"arspiffyblue" wrote in message
...
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)