View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tushar Mehta[_6_] Tushar Mehta[_6_] is offline
external usenet poster
 
Posts: 19
Default 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?