[Solved] Excel solver: Error Log 3_Decimal result after non negative constraint

Error phenomenon: after adding non-negative constraint to solver, the calculation result is still decimal


Solution:
uncheck ‘ignore integer constraints’ in the options of the solver

integer results appear:

Read More: