| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I enter cell references in "Equal to" box in solver
|
|
#2
|
|||
|
|||
|
You can't
-- Regards, Peo Sjoblom (No private emails please) "jhelp" wrote in message ... |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why do I have to enter the cell (F2) for cell to calculate? | Excel Discussion (Misc queries) | |||
| cell color index comparison | New Users to Excel | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Syntax for inferred cell references | Excel Worksheet Functions | |||
| Cell References and External Data | Excel Worksheet Functions | |||
Linear Mode
