<div>
You're right... I was hoping for some sort of magic formula, I guess, but I finally rolled up my sleeves to try and figure out what the heck was happening in the background, and once I figured out what that function did, I was able to replicate some code (had to create a while loop to iterate through the target value, and re-calculate all functions).<br />
<br />
Thanks,<br />
<br />
Julie
</div>


You're right... I was hoping for some sort of magic formula, I guess, but I finally rolled up my sleeves to try and figure out what the heck was happening in the background, and once I figured out what that function did, I was able to replicate some code (had to create a while loop to iterate through the target value, and re-calculate all functions).

Thanks,

Julie

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I am in the process of moving over an Excel spreasheet with macros in it to a web application. &nbsp;All is well, except for this one cell which contains within it a GOALSEEK function. I have no idea what the algorithm is to replicate this function, or if I can import some DLL to simply access it... Help!<br />
<br />
Thanks in advance,<br />
<br />
Julie<br />
<br />
Range(&quot;E31&quot;).GoalSeek Goal:=0, ChangingCell:=Range(&quot;D31&quot;)<wbr />
</div>
</div>


Hello,

I am in the process of moving over an Excel spreasheet with macros in it to a web application.  All is well, except for this one cell which contains within it a GOALSEEK function. I have no idea what the algorithm is to replicate this function, or if I can import some DLL to simply access it... Help!

Thanks in advance,

Julie

Range("E31").GoalSeek Goal:=0, ChangingCell:=Range("D31")

Need to write a GoalSeek function in C#

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).