You can't
--
Regards,
Peo Sjoblom
(No private emails please)
"jhelp" <[email protected]> wrote in message
news:[email protected]...
>
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.
In article <[email protected]>,
[email protected] 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks