Thread
:
Is Solver Modification Possible? PLEASE HELP!
View Single Post
#
2
Posted to microsoft.public.excel.programming
Tushar Mehta[_6_]
external usenet poster
Posts: 19
Is Solver Modification Possible? PLEASE HELP!
What are "variable constants?" And what does it mean to
"[embed]...Solver within the Excel Solver code?"
It seems you want to fit a linear function to some data. If so, look
up XL help for the LINEST function.
--
Regards,
Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article ,
says...
I have an equation I am attempting to fit to some data via 2 variable
constants. However, my equation can't be solved directly. I CAN solve
this equation for my data result variable, but I have to use goalseek
or solver. I want to perform a minimization of a sum of the square of
the differences of my data values and my data result variable. To do
this I would need to imbed a goalseek or solver within the Excel Solver
code. Can anyone help me?
Reply With Quote
Tushar Mehta[_6_]
View Public Profile
Find all posts by Tushar Mehta[_6_]