Posted to microsoft.public.excel.worksheet.functions

gila_cokelat gila_cokelat is offline

external usenet poster

Posts: 1

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
define cell	Sanjiv	Excel Worksheet Functions	4	September 2nd 08 03:46 PM
Cannot define cell name from menu	kufdam	Setting up and Configuration of Excel	0	January 9th 07 03:32 PM
define one cell location throughout workbook?	New_to_accounting	Excel Worksheet Functions	3	September 2nd 06 12:36 AM
Define Name in active cell	Danny	Excel Worksheet Functions	0	October 13th 05 06:20 PM
how to define a cell to where i can link to it.	daneyb	Excel Discussion (Misc queries)	6	March 13th 05 07:27 PM

All times are GMT +1. The time now is 09:53 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us