CODEWITHSUNDEEP
c#
Joan Manuel Toro Ortiz
Joan Manuel Toro Ortiz

Reputation: 21

Excel Function Goal Seek Equivalent Algorithm in C #

Before discussing my problem, I tell you the business context.

I need to automate a credit simulator now used in Excel, which uses the Goal Seek function to calculate the gross amount of credit.

The only thing I need to automate is the calculation of the gross amount, but to achieve that I need the Goal Seek function of Excel in C # or JS, that's why I turn to you to find an algorithm, library or code to solve this calculation.

Use TridentGoalSeek but you do not have much documentation on how to use this library.

Thank you in advance for your support. Regards!

Upvotes: 2

Views: 4055

Answers (1)

Ahmed
Ahmed

Reputation: 101

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

Upvotes: 3

Related Questions