View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tushar Mehta Tushar Mehta is offline
external usenet poster
 
Posts: 1,071
Default Solver - Minimize an absolute value

If use of a linear model is a requirement it would seem like a HW
assignment. Maybe if you share more details about what you are trying
to do someone might be able to suggest an alternative model that is
indeed linear.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
. says...
I am trying to minimize the absolute value difference between two numbers.
The challenge is that solver sees -45 as a better anwer than -1; I'm trying
to hit zero if at all possible.
When I use the "abs" function my solver spits out the "@@# does not
conform to a linear model". Assume linear model is a requirement in my
application.

Any ideas?