Forum Discussion

Tzeh Ong's avatar
Tzeh Ong
Copper Contributor
Mar 12, 2018

Solver function constraint

I am looking for a way to optimize an output, with the constraints for the variables not to be more than 3 decimal places without any rounding.  For e.g, I want to change the CL while constraining all the Z columns to be less than 3 decimal places. I am looking to the solver function but can't see a way to make a decimal constraint.  Can anyone help?

 

  20% 30% 5% 5%
CL Z Z Tier 1 Z Tier2 Z Tier3
                                 1.25 1 0.875 0.95 0.83125

Resources