how to solve this in excel

[Daif_h]

Hello everyone, i've stumbled with this small puzzle:

you have to arrange the numbers from 1 to 9 to make this horizontally and vertically correct:

---- + ---- + ---- = 15
---- + ---- + ---- = 16
---- + ---- + ---- = 14
= = =
16 15 14

i've already solved it with trying some possibilities, but then i asked my self if i can make a formula that can mathematically solve it, and from there depending on excel in doing that..
i won't bother you with reading the formulas that i've wrote (4 pages till now) and i'm starting with 9 variables which is very complicated
and maybe it's good to know that i'm not expert neither in excel nor math, really hope that someone of you have the time to guide me through this
and Happy Easter

 

[xrichardx]

It's SUDOKU? Did you already tried to break the puzzle program itself?

Cheers
Chard

 

[AliGW]

Did it manually in five minutes:

[TABLE="width: 192"]
<colgroup><col style="width:48pt" span="3" width="64"> </colgroup><tbody>[TR]
[TD="width: 64, align: right"]6[/TD]
[TD="width: 64, align: right"]5[/TD]
[TD="width: 64, align: right"]4[/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]9[/TD]
[/TR]
</tbody>[/TABLE]

Just used Excel to check my totals and kept swapping numbers until they matched the desired result.

Doesn't help you to automate the process, though ...

 

[Daif_h]

in principle it has something from Sudoku... solving it is not the problem though... keep the ideas coming

 

[Daif_h]

AliGW... yes your answer don't help with the process but it proved that there is more than one solution for this puzzle
cause it's differ than my solution (which i don't remember but the 9 was in the other corner)
keep the ideas coming

 

[AliGW]

AliGW... yes your answer don't help with the process but it proved that there is more than one solution for this puzzle
cause it's differ than my solution (which i don't remember but the 9 was in the other corner)
keep the ideas coming

Well, there will be several solutions, I'm sure.

Could have been this:

[TABLE="width: 192"]
<colgroup><col style="width:48pt" span="3" width="64"> </colgroup><tbody>[TR]
[TD="width: 64, align: right"]9[/TD]
[TD="width: 64, align: right"]2[/TD]
[TD="width: 64, align: right"]4[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]3[/TD]
[/TR]
</tbody>[/TABLE]

 

[AliGW]

This is what I'm using to solve it manually:

[TABLE="width: 411"]
<tbody>[TR]
[TD="align: center"]9
[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]15[/TD]
[TD="align: center"]=SUM(A1:C1)[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]16[/TD]
[TD="align: center"]=SUM(A2:C2)[/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]14[/TD]
[TD="align: center"]=SUM(A3:C3)[/TD]
[/TR]
[TR]
[TD="align: center"]16[/TD]
[TD="align: center"]15[/TD]
[TD="align: center"]14[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]=SUM(A1:A3)[/TD]
[TD="align: center"]=SUM(B1:B3)[/TD]
[TD="align: center"]=SUM(C1:C3)[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
</tbody>[/TABLE]

 

[Daif_h]

still no formula, come on guys work with me
show me some excel solver, the IF ... something....
i started with x + z + y = 15 and then to get rid of the possibility of any of the variables equal zero i thought of:
(1+x) + (1+y) + (1+z) = 15 and that's equal x+y+z= 13 and so on...
keep the ideas coming