How do I enter cell references in "Equal to" box in solver
 

You can't

--
Regards,

Peo Sjoblom

(No private emails please)


"jhelp" wrote in message
...

In article ,
says...


There are a few different ways. Here's one:

Suppose your target cell is B12 and the cell containing the target
value is C12. Then, in a third cell, say D12, enter =B12-C12. Now,
use D12 as the target cell and a target value of zero.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

Usually, you can work around this. In a third cell enter the formula
=targetcell-referencecell. Then, in Solver, your new target cell is
this third cell, and you try to set it equal to a value of 0.


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=468564