Excel Function Goal Seek Equivalent Algorithm in C

0 votes
I'll first describe my business background before talking about my difficulty.

I need to automate an Excel credit simulator that determines the gross amount of credit using the Goal Seek function. I only need to automate the calculation of the gross amount, and in order to do so, I need the Goal Seek function of Excel in C# or JS. Because of this, I'm asking you for an algorithm, library, or piece of code that will help me automate this calculation.

Although there isn't much instruction on how to utilize this library, use TridentGoalSeek.
Oct 16 in Others by Kithuzzz
• 20,660 points
98 views

1 answer to this question.

0 votes

Nuget has libraries available like Trident.GoalSeek and Budoom.GoalSeek.

Budoom.GoalSeek has an open-source implementation available on [GitHub] (https://github.com/bayazidahmed/Budoom.GoalSeek/blob/master/README.md).

Sample usage and link to the nuget packages available at Excel GoalSeek algorithm

answered Oct 17 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer
0 votes
1 answer

IF function in combination with an Round function Excel

I'm not sure if it is a ...READ MORE

answered Sep 25 in Others by narikkadan
• 37,660 points
67 views
0 votes
1 answer

Equivalent of Excel Round function

Here's a sample LINQPad program that demonstrates one way ...READ MORE

answered Sep 26 in Others by narikkadan
• 37,660 points
60 views
0 votes
1 answer

How to use the INDIRECT function in Excel

Try this: =INDEX(INDIRECT($A$1&"!$1:$1048576"),MATCH($B$1,INDI ...READ MORE

answered Sep 29 in Others by narikkadan
• 37,660 points
77 views
0 votes
1 answer

Generate a flat list of all excel cell formulas

Hello, you'll have to follow certain steps ...READ MORE

answered Feb 18 in Others by gaurav
• 22,040 points
80 views
0 votes
1 answer

Convert a number to a letter in C# for use in Microsoft Excel [duplicate]

If you are familiar with using formulas ...READ MORE

answered Feb 23 in Database by gaurav
• 22,040 points
147 views
0 votes
1 answer

Deleting duplicate rows in Excel using Epplus

You need to re-think this… the while ...READ MORE

answered Feb 23 in Database by gaurav
• 22,040 points
302 views
0 votes
1 answer

Export DataTable to Excel File

Add Interop References. First we need to ...READ MORE

answered Jun 9 in JQuery by gaurav
• 22,040 points
123 views
0 votes
1 answer

How to use goal seek function in Excel user function?

In the Microsoft Excel Object-Sheet1(Sheet1), we can ...READ MORE

answered Oct 28 in Others by narikkadan
• 37,660 points
59 views
0 votes
1 answer

Goal Seek in Excel

The pmt function we are using, which ...READ MORE

answered Sep 30 in Others by narikkadan
• 37,660 points
80 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP