ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Define cell value in a matrix to add up 2 constraints value (https://www.excelbanter.com/excel-worksheet-functions/228623-define-cell-value-matrix-add-up-2-constraints-value.html)

gila_cokelat

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