Thread
:
Solver - Minimize an absolute value
View Single Post
#
1
Posted to microsoft.public.excel.programming
Tushar Mehta
external usenet poster
Posts: 1,071
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?
Reply With Quote
Tushar Mehta
View Public Profile
Find all posts by Tushar Mehta