https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/104625&feed=atom&action=history
Microsoft KB Archive/104625 - Revision history
2024-03-28T12:20:37Z
Revision history for this page on the wiki
MediaWiki 1.39.3
https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/104625&diff=272983&oldid=prev
X010: Text replacement - "<" to "<"
2020-07-20T14:05:00Z
<p>Text replacement - "<" to "<"</p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en-GB">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 14:05, 20 July 2020</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l40">Line 40:</td>
<td colspan="2" class="diff-lineno">Line 40:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>...the number of cells in the range must match the number of cell in "cell_ref," although the shape of the areas need not be the same.<br /></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>...the number of cells in the range must match the number of cell in "cell_ref," although the shape of the areas need not be the same.<br /></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br /></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br /></div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>This information is not entirely correct. A many-to-one ratio is acceptable. For example, "A1:A4 <del style="font-weight: bold; text-decoration: none;">&lt;</del>= B1" will work properly.</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>This information is not entirely correct. A many-to-one ratio is acceptable. For example, "A1:A4 <ins style="font-weight: bold; text-decoration: none;"><</ins>= B1" will work properly.</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=== SOLVER.DELETE() ===</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=== SOLVER.DELETE() ===</div></td></tr>
<tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l46">Line 46:</td>
<td colspan="2" class="diff-lineno">Line 46:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* The Remarks section on page 408 states that "The 'formula' argument is not used."<br /></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* The Remarks section on page 408 states that "The 'formula' argument is not used."<br /></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br /></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br /></div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>This information is not entirely correct. If there are two or more constraints for which "cell_ref" and "relation" are the same (for example, A1 <del style="font-weight: bold; text-decoration: none;">&lt;</del>= 5 and A1 <del style="font-weight: bold; text-decoration: none;">&lt;</del>= B1), the "formula" argument is not ignored.</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>This information is not entirely correct. If there are two or more constraints for which "cell_ref" and "relation" are the same (for example, A1 <ins style="font-weight: bold; text-decoration: none;"><</ins>= 5 and A1 <ins style="font-weight: bold; text-decoration: none;"><</ins>= B1), the "formula" argument is not ignored.</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=== SOLVER.LOAD() ===</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=== SOLVER.LOAD() ===</div></td></tr>
</table>
X010
https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/104625&diff=262636&oldid=prev
X010: Text replacement - """ to """
2020-07-20T08:34:45Z
<p>Text replacement - """ to """</p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en-GB">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 08:34, 20 July 2020</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l21">Line 21:</td>
<td colspan="2" class="diff-lineno">Line 21:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== SUMMARY ==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== SUMMARY ==</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>Pages 407-413 of the <del style="font-weight: bold; text-decoration: none;">&quot;</del>Function Reference,<del style="font-weight: bold; text-decoration: none;">&quot; </del>contain incorrect information about the SOLVER functions. For information about a particular SOLVER function, see the appropriate section below.</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>Pages 407-413 of the <ins style="font-weight: bold; text-decoration: none;">"</ins>Function Reference,<ins style="font-weight: bold; text-decoration: none;">" </ins>contain incorrect information about the SOLVER functions. For information about a particular SOLVER function, see the appropriate section below.</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br /></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br /></div></td></tr>
<tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l30">Line 30:</td>
<td colspan="2" class="diff-lineno">Line 30:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=== SOLVER.ADD() ===</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=== SOLVER.ADD() ===</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>* The first paragraph of the second column on page 407 states that the formula <del style="font-weight: bold; text-decoration: none;">&quot;</del>may be a formula (as text) or a reference to a range of cells.<del style="font-weight: bold; text-decoration: none;">&quot; </del>This section should also note that if the formula is entered as text and contains any references, the references must be entered using R1C1 notation.</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>* The first paragraph of the second column on page 407 states that the formula <ins style="font-weight: bold; text-decoration: none;">"</ins>may be a formula (as text) or a reference to a range of cells.<ins style="font-weight: bold; text-decoration: none;">" </ins>This section should also note that if the formula is entered as text and contains any references, the references must be entered using R1C1 notation.</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* The first bulleted item in the right column on page 407 states:<br /></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* The first bulleted item in the right column on page 407 states:<br /></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br /></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br /></div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>If <del style="font-weight: bold; text-decoration: none;">&quot;</del>relation<del style="font-weight: bold; text-decoration: none;">&quot; </del>is 4, <del style="font-weight: bold; text-decoration: none;">&quot;</del>formula<del style="font-weight: bold; text-decoration: none;">&quot; </del>is ignored, and <del style="font-weight: bold; text-decoration: none;">&quot;</del>cell_ref<del style="font-weight: bold; text-decoration: none;">&quot; </del>must be a subset of the By Changing Cells.<br /></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>If <ins style="font-weight: bold; text-decoration: none;">"</ins>relation<ins style="font-weight: bold; text-decoration: none;">" </ins>is 4, <ins style="font-weight: bold; text-decoration: none;">"</ins>formula<ins style="font-weight: bold; text-decoration: none;">" </ins>is ignored, and <ins style="font-weight: bold; text-decoration: none;">"</ins>cell_ref<ins style="font-weight: bold; text-decoration: none;">" </ins>must be a subset of the By Changing Cells.<br /></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br /></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br /></div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>This information is incorrect. If <del style="font-weight: bold; text-decoration: none;">&quot;</del>relation<del style="font-weight: bold; text-decoration: none;">&quot; </del>is 4, <del style="font-weight: bold; text-decoration: none;">&quot;</del>formula<del style="font-weight: bold; text-decoration: none;">&quot; </del>is not ignored. You must use either <del style="font-weight: bold; text-decoration: none;">&quot;</del>=integer<del style="font-weight: bold; text-decoration: none;">&quot; </del>or <del style="font-weight: bold; text-decoration: none;">&quot;</del>integer<del style="font-weight: bold; text-decoration: none;">&quot; </del>(including the quotation marks) for <del style="font-weight: bold; text-decoration: none;">&quot;</del>formula.<del style="font-weight: bold; text-decoration: none;">&quot;</del></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>This information is incorrect. If <ins style="font-weight: bold; text-decoration: none;">"</ins>relation<ins style="font-weight: bold; text-decoration: none;">" </ins>is 4, <ins style="font-weight: bold; text-decoration: none;">"</ins>formula<ins style="font-weight: bold; text-decoration: none;">" </ins>is not ignored. You must use either <ins style="font-weight: bold; text-decoration: none;">"</ins>=integer<ins style="font-weight: bold; text-decoration: none;">" </ins>or <ins style="font-weight: bold; text-decoration: none;">"</ins>integer<ins style="font-weight: bold; text-decoration: none;">" </ins>(including the quotation marks) for <ins style="font-weight: bold; text-decoration: none;">"</ins>formula.<ins style="font-weight: bold; text-decoration: none;">"</ins></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* The second bulleted item in the right column of page 407 states:<br /></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* The second bulleted item in the right column of page 407 states:<br /></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br /></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br /></div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>...the number of cells in the range must match the number of cell in <del style="font-weight: bold; text-decoration: none;">&quot;</del>cell_ref,<del style="font-weight: bold; text-decoration: none;">&quot; </del>although the shape of the areas need not be the same.<br /></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>...the number of cells in the range must match the number of cell in <ins style="font-weight: bold; text-decoration: none;">"</ins>cell_ref,<ins style="font-weight: bold; text-decoration: none;">" </ins>although the shape of the areas need not be the same.<br /></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br /></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br /></div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>This information is not entirely correct. A many-to-one ratio is acceptable. For example, <del style="font-weight: bold; text-decoration: none;">&quot;</del>A1:A4 &lt;= B1<del style="font-weight: bold; text-decoration: none;">&quot; </del>will work properly.</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>This information is not entirely correct. A many-to-one ratio is acceptable. For example, <ins style="font-weight: bold; text-decoration: none;">"</ins>A1:A4 &lt;= B1<ins style="font-weight: bold; text-decoration: none;">" </ins>will work properly.</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=== SOLVER.DELETE() ===</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=== SOLVER.DELETE() ===</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>* The Remarks section on page 408 states that <del style="font-weight: bold; text-decoration: none;">&quot;</del>The 'formula' argument is not used.<del style="font-weight: bold; text-decoration: none;">&quot;</del><br /></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>* The Remarks section on page 408 states that <ins style="font-weight: bold; text-decoration: none;">"</ins>The 'formula' argument is not used.<ins style="font-weight: bold; text-decoration: none;">"</ins><br /></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br /></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br /></div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>This information is not entirely correct. If there are two or more constraints for which <del style="font-weight: bold; text-decoration: none;">&quot;</del>cell_ref<del style="font-weight: bold; text-decoration: none;">&quot; </del>and <del style="font-weight: bold; text-decoration: none;">&quot;</del>relation<del style="font-weight: bold; text-decoration: none;">&quot; </del>are the same (for example, A1 &lt;= 5 and A1 &lt;= B1), the <del style="font-weight: bold; text-decoration: none;">&quot;</del>formula<del style="font-weight: bold; text-decoration: none;">&quot; </del>argument is not ignored.</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>This information is not entirely correct. If there are two or more constraints for which <ins style="font-weight: bold; text-decoration: none;">"</ins>cell_ref<ins style="font-weight: bold; text-decoration: none;">" </ins>and <ins style="font-weight: bold; text-decoration: none;">"</ins>relation<ins style="font-weight: bold; text-decoration: none;">" </ins>are the same (for example, A1 &lt;= 5 and A1 &lt;= B1), the <ins style="font-weight: bold; text-decoration: none;">"</ins>formula<ins style="font-weight: bold; text-decoration: none;">" </ins>argument is not ignored.</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=== SOLVER.LOAD() ===</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=== SOLVER.LOAD() ===</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* This function does not work when applied to a worksheet unless the worksheet has already had a Solver model saved onto it.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* This function does not work when applied to a worksheet unless the worksheet has already had a Solver model saved onto it.</div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>* The first bulleted item in the left column of page 410 states <del style="font-weight: bold; text-decoration: none;">&quot;</del>The last cell optionally contains an array of Solver option values (see SOLVER.OPTIONS).<del style="font-weight: bold; text-decoration: none;">&quot;</del></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>* The first bulleted item in the left column of page 410 states <ins style="font-weight: bold; text-decoration: none;">"</ins>The last cell optionally contains an array of Solver option values (see SOLVER.OPTIONS).<ins style="font-weight: bold; text-decoration: none;">"</ins></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>The SOLVER.OPTIONS() function uses a array that is in a different order than the array used by SOLVER.LOAD(); therefore, this statement should read:<br /></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>The SOLVER.OPTIONS() function uses a array that is in a different order than the array used by SOLVER.LOAD(); therefore, this statement should read:<br /></div></td></tr>
<tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l65">Line 65:</td>
<td colspan="2" class="diff-lineno">Line 65:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=== SOLVER.RESET() ===</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=== SOLVER.RESET() ===</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>The description of the SOLVER.RESET() function states that this function <del style="font-weight: bold; text-decoration: none;">&quot;</del>is performed automatically when you call SOLVER.LOAD.<del style="font-weight: bold; text-decoration: none;">&quot; </del>This information is not entirely correct: SOLVER.RESET() does not reset the options, and so previously set options will be used unless the SOLVER.LOAD() model includes new options settings.<br /></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>The description of the SOLVER.RESET() function states that this function <ins style="font-weight: bold; text-decoration: none;">"</ins>is performed automatically when you call SOLVER.LOAD.<ins style="font-weight: bold; text-decoration: none;">" </ins>This information is not entirely correct: SOLVER.RESET() does not reset the options, and so previously set options will be used unless the SOLVER.LOAD() model includes new options settings.<br /></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br /></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br /></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l121">Line 121:</td>
<td colspan="2" class="diff-lineno">Line 121:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== SOLVER.SOLVE?() ==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== SOLVER.SOLVE?() ==</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>Page 412 of the <del style="font-weight: bold; text-decoration: none;">&quot;</del>Function Reference<del style="font-weight: bold; text-decoration: none;">&quot; </del>suggests that the SOLVER.SOLVE?() form of the SOLVER.SOLVE() function exists. This information is incorrect: there is no such command.</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>Page 412 of the <ins style="font-weight: bold; text-decoration: none;">"</ins>Function Reference<ins style="font-weight: bold; text-decoration: none;">" </ins>suggests that the SOLVER.SOLVE?() form of the SOLVER.SOLVE() function exists. This information is incorrect: there is no such command.</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br /></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br /></div></td></tr>
<tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l128">Line 128:</td>
<td colspan="2" class="diff-lineno">Line 128:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== REFERENCES ==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== REFERENCES ==</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">&quot;</del>Function Reference,<del style="font-weight: bold; text-decoration: none;">&quot; </del>pages 407-413</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">"</ins>Function Reference,<ins style="font-weight: bold; text-decoration: none;">" </ins>pages 407-413</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Additional query words: add-in 4.00a</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Additional query words: add-in 4.00a</div></td></tr>
</table>
X010
https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/104625&diff=48469&oldid=prev
3155ffGd: importing KB archive
2020-07-18T15:03:45Z
<p>importing KB archive</p>
<p><b>New page</b></p><div>{|<br />
|width="100%"|<br />
== XL: Problems with SOLVER Functions ==<br />
|}<br />
<br />
<br />
-----<br />
<br />
The information in this article applies to:<br /><br />
<br />
<br />
* Microsoft Excel for Windows, versions 4.0, 4.0a<br />
* Microsoft Excel for the Macintosh, version 4.0<br />
<br />
<br />
-----<br />
<br />
<br /><br />
<br />
<br />
== SUMMARY ==<br />
<br />
Pages 407-413 of the &quot;Function Reference,&quot; contain incorrect information about the SOLVER functions. For information about a particular SOLVER function, see the appropriate section below.<br />
<br />
<br /><br />
<br />
<br />
== MORE INFORMATION ==<br />
<br />
=== SOLVER.ADD() ===<br />
<br />
* The first paragraph of the second column on page 407 states that the formula &quot;may be a formula (as text) or a reference to a range of cells.&quot; This section should also note that if the formula is entered as text and contains any references, the references must be entered using R1C1 notation.<br />
* The first bulleted item in the right column on page 407 states:<br /><br />
<br /><br />
If &quot;relation&quot; is 4, &quot;formula&quot; is ignored, and &quot;cell_ref&quot; must be a subset of the By Changing Cells.<br /><br />
<br /><br />
This information is incorrect. If &quot;relation&quot; is 4, &quot;formula&quot; is not ignored. You must use either &quot;=integer&quot; or &quot;integer&quot; (including the quotation marks) for &quot;formula.&quot;<br />
* The second bulleted item in the right column of page 407 states:<br /><br />
<br /><br />
...the number of cells in the range must match the number of cell in &quot;cell_ref,&quot; although the shape of the areas need not be the same.<br /><br />
<br /><br />
This information is not entirely correct. A many-to-one ratio is acceptable. For example, &quot;A1:A4 &lt;= B1&quot; will work properly.<br />
<br />
=== SOLVER.DELETE() ===<br />
<br />
* The Remarks section on page 408 states that &quot;The 'formula' argument is not used.&quot;<br /><br />
<br /><br />
This information is not entirely correct. If there are two or more constraints for which &quot;cell_ref&quot; and &quot;relation&quot; are the same (for example, A1 &lt;= 5 and A1 &lt;= B1), the &quot;formula&quot; argument is not ignored.<br />
<br />
=== SOLVER.LOAD() ===<br />
<br />
* This function does not work when applied to a worksheet unless the worksheet has already had a Solver model saved onto it.<br />
* The first bulleted item in the left column of page 410 states &quot;The last cell optionally contains an array of Solver option values (see SOLVER.OPTIONS).&quot;<br />
<br />
The SOLVER.OPTIONS() function uses a array that is in a different order than the array used by SOLVER.LOAD(); therefore, this statement should read:<br /><br />
<br /><br />
<br />
<br />
<pre class="FIXEDTEXT"> The order of the options is the same as the top-to-bottom order in<br />
the Solver Options dialog box. </pre><br />
<br /><br />
<br /><br />
<br />
<br />
=== SOLVER.RESET() ===<br />
<br />
The description of the SOLVER.RESET() function states that this function &quot;is performed automatically when you call SOLVER.LOAD.&quot; This information is not entirely correct: SOLVER.RESET() does not reset the options, and so previously set options will be used unless the SOLVER.LOAD() model includes new options settings.<br /><br />
<br /><br />
<br />
<br />
=== SOLVER.SOLVE() ===<br />
<br />
The values and stopping conditions listed on page 413 are incorrect. The correct values and Stopping conditions are:<br /><br />
<br /><br />
<br />
<br />
<pre class="FIXEDTEXT"> Value Stopping condition<br />
---------------------------------------------------<br />
<br />
0 Solver found a solution. All constraints and<br />
optimal conditions are satisfied.<br />
<br />
1 Solver has converged to the current solution. All<br />
constraints are satisfied.<br />
<br />
2 Solver cannot improve the current solution. All<br />
constraints are satisfied.<br />
<br />
3 Stop chosen when the maximum iteration limit was<br />
reached.<br />
<br />
4 The Set Cell values do not converge.<br />
<br />
5 Solver could not find a feasible solution.<br />
<br />
6 Solver stopped at user's request.<br />
<br />
7 The conditions for Assume Linear Model are not<br />
satisfied.<br />
<br />
8 The problem is too large for Solver to handle.<br />
<br />
9 Solver encountered an error value in a target or<br />
constraint cell.<br />
<br />
10 Stop chosen when the maximum time limit was<br />
reached.<br />
<br />
11 There is not enough memory available to solve the<br />
problem.<br />
<br />
12 Another Microsoft Excel instance is using<br />
SOLVER.DLL(). Try again later.<br />
<br />
13 Error in model. Please verify that all cells and<br />
constraints are valid. </pre><br />
<br /><br />
<br /><br />
<br />
<br />
== SOLVER.SOLVE?() ==<br />
<br />
Page 412 of the &quot;Function Reference&quot; suggests that the SOLVER.SOLVE?() form of the SOLVER.SOLVE() function exists. This information is incorrect: there is no such command.<br />
<br />
<br /><br />
<br />
<br />
== REFERENCES ==<br />
<br />
&quot;Function Reference,&quot; pages 407-413<br />
<br />
Additional query words: add-in 4.00a<br />
<br />
Keywords : kbmacro<br /><br />
Version : WINDOWS:4.0,4.0a; MACINTOSH:4.0<br /><br />
Platform : MACINTOSH WINDOWS<br /><br />
Issue type :<br /><br />
Technology :<br />
<br />
{|<br />
|width="100%"| <br /><br />
Last Reviewed: April 7, 1999<br /><br />
<span>© 2000 Microsoft Corporation. All rights reserved. Terms of Use.</span><br /><br />
|}</div>
3155ffGd