Excel Solver

[tennisbuck]

Hello. I'm using Excel Solver and have 2 tables. Table one is prices where my variables cells need to be greater. Table 2 is prices where I want my variable cells to be lower. How should I set this up? I want to maximize my markup between these two ranges.

 

[tennisbuck]

Hello. I'm using Excel Solver and have 2 tables. Table one is prices where my variables cells need to be greater. Table 2 is prices where I want my variable cells to be lower. How should I set this up? I want to maximize my markup between these two ranges.

Help!

 

[xenou]

Hi,
I don't think "having two tables" is enough information to give direction on how to setup a solver solution. You'll have to be more specific. I don't use solver frequently, but typically you have one cell that you want to maximize or minimize (or set equal to), and other cells that act as constraints.