# GrapeCity.Documents.Excel.IRange.GoalSeek

## Content

<div class="doc-site-dotnet-api-container">



<h1 id="GrapeCity_Documents_Excel_IRange_GoalSeek_" data-uid="GrapeCity.Documents.Excel.IRange.GoalSeek*">GoalSeek Method
</h1>
<div class="markdown level0 summary"></div>
<div class="markdown level0 conceptual"></div>



<a id="GrapeCity_Documents_Excel_IRange_GoalSeek_" data-uid="GrapeCity.Documents.Excel.IRange.GoalSeek*"></a>
<h4 id="GrapeCity_Documents_Excel_IRange_GoalSeek_System_Double_GrapeCity_Documents_Excel_IRange_" data-uid="GrapeCity.Documents.Excel.IRange.GoalSeek(System.Double,GrapeCity.Documents.Excel.IRange)">GoalSeek(double, IRange)</h4>
<div class="markdown level1 summary"><p>Attempts to achieve the specified goal, from the calculated result of the formula in the cell represented by this IRange, by modifying the specified changingCell.
If you know the result that you want from a formula, but are not sure what input value the formula needs to get that result, use the Goal Seek feature.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">bool GoalSeek(double goal, IRange changingCell)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Function GoalSeek(goal As Double, changingCell As IRange) As Boolean</code></pre>
</div>
<h5 class="parameters">Parameters</h5>
<table class="table table-bordered table-condensed">
  <thead>
    <tr>
      <th>Type</th>
      <th>Name</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.double">double</a></td>
      <td><span class="parametername">goal</span></td>
      <td><p>Specifies the desired goal value.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="GrapeCity.Documents.Excel.IRange.html">IRange</a></td>
      <td><span class="parametername">changingCell</span></td>
      <td><p>Specifies the cell to change.</p>
</td>
    </tr>
  </tbody>
</table>
<h5 class="returns">Returns</h5>
<table class="table table-bordered table-condensed">
  <thead>
    <tr>
      <th>Type</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><p>True if the desired result value is successfully found, otherwise False.</p>
</td>
    </tr>
  </tbody>
</table>
</div>