Define cell value in a matrix to add up 2 constraints value
I have a matrix to match same SUM value (550) from left-right and up-down
X Y Z Total A 100 90 80 270 B 70 0 60 130 C 0 50 40 150 TARGET 200 150 200 550 VARIANCE 30 10 20 Seems like I still have discrepancy with up-down summary. I must change matrix (AX : CZ cells) value so that don't affect my left-right summary. How to use solver for this? |
All times are GMT +1. The time now is 03:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com