Forum Discussion

abbe1992's avatar
abbe1992
Copper Contributor
May 11, 2021
Solved

Design optimization using discrete decision variables

Hi!   I have a linear equation system that is based on a couple of input variables (x,y,z,w).  The variables can only have certain values, e.g. x=[1 2 3 ... 50], y=[0.1 0.2 ... 20], z=[5 10 15 ......
  • HansVogelaar's avatar
    May 11, 2021

    abbe1992 

    Solver can constrain input variable to be whole numbers. You could use formulas to convert for example input 1, 2, ..., 50 to 0.1, 0.2, 50.0

    Solver will use B2 to B5 as variables, but your target formula should refer to C2 to C5.

    In the screenshot, F2:G5 is a lookup table for C5; the formula in C5 is =VLOOKUP(B5,F1:G5,2,FALSE)

Resources