I got a range of Changing Variables that I need to solve to achieve an optimal solution. The problem is that solver keeps changing them by some super high precision 0.000000000
I want Solver to only change them by 0.00 (2 decimal places) max.
How can I do this? I tried to play around with the precision option but it looks like that relates to the Constraint and not the changing variables
Any help is appreciated
There is an option to set acurracy of calculations as displayed.
Options, Advanced, When calculating this workbook, acurracy of calculations as displayed
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Are you sure you are not confusing with the accuracy of the Constraint? I cannot find anything related to the Changing VariablesOriginally Posted by mehmetcik
I already formatted the cell range to be 2 decimals long but it seems that Solver overrides that and doesnt care
Last edited by Bulrathi; 01-01-2017 at 06:58 PM.
In a column A set the display as decimal with two decimal places
Enter the formulainto A1Formula:
=22/7
In B1 enter the formula =A1*7 you will get the value 22.
Set the accuracy as displayed and enter =A1*7 in B1 and the value you now get will be 21.98
accuracy as displayed worked. very goodIn a column A set the display as decimal with two decimal places
Enter the formulainto A1Formula:=22/7
In B1 enter the formula =A1*7 you will get the value 22.
Set the accuracy as displayed and enter =A1*7 in B1 and the value you now get will be 21.98
now if I could only solve this
http://www.excelforum.com/showthread...8232&p=4551803
everything would work perfectly
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Bulrathi 
Register To Reply
Bookmarks