Decision Optimization

Decision Optimization

Delivers prescriptive analytics capabilities and decision intelligence to improve decision-making.


#Analytics
#DecisionOptimization
#DecisionOptimization
 View Only
Back to discussions
Expand all | Collapse all

SUMPRODUCT with logical values

  • 1.  SUMPRODUCT with logical values

    Posted 02/19/13 11:47 AM

    Originally posted by: SystemAdmin


    Hi,
    I am using Excel 2010 and I have cplex_studio125.win-x86-64 installed.

    I am using SUMPRODUCT in a constraint, the exact formula is: SUMPRODUCT(($B$13:$B$50=R13)*1,$F$13:$F$50) which produces TRUE and FALSE values. Solving the model, I get error 24: "cannot convert value into number" for this cell.

    The user manual (ftp://ftp.software.ibm.com/software/websphere/ilog/docs/optimization/cplex/cplex_excel_user.pdf) says that logical values are treated as NAN instead of 0 and 1. I guess this is the problem.

    I used SUMIF($B$13:$B$50,R13,$F$13:$F$50) instead, which works fine but takes a lot of time. is there any other formula I could use to avoid the logical values?

    Thanks!
    Steffen
    #CPLEXOptimizers
    #DecisionOptimization


Related Content