Forum Discussion
Divide a quantity as whole number among multiple cells
Hello, Any suggestion for an excel formula to derive A2, B2, C2, D2 values. Eg: Category X A B C D P1 4 1 1 1 1 P2 3 0 1 1 1 P3 2 0 1 1 0 Y 1 3 3 2 ...
Solver works with evolutionary search over binary values.
Yellow = variables
Blue = constraints
Green = objective