Solving simultaneous Equations with MMULT AND MINVERSE

[andreascostas]

G H J
[TABLE="width: 524"]
<tbody>[TR]
[TD]- 8x - 8y = 12
[/TD]
[TD]-8
[/TD]
[TD]-8
[/TD]
[TD]12
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]x=
[/TD]
[TD]#NUM!
[/TD]
[/TR]
[TR]
[TD]- 6x - 6y = -102
[/TD]
[TD]-6
[/TD]
[TD]-6
[/TD]
[TD]-102
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]y=
[/TD]
[TD]#NUM!
[/TD]
[/TR]
</tbody>[/TABLE]

I am working on simultaneous equations using {=mmult(minverse(g2:h3),J2:23)}.
When there is a solution it works and gives me the correct answer. When there are no solutions
Or an infinite number of solutions I get #NUM……I need the answer cell to state “ No Solution” if there is no solution or an “ Infinite Number of Solutions” if there are infinite solutions and the correct answer
When it has only one answer.

 

[StephenCrump]

If you're only working with 2x2 matrices (?) it's fairly simple:

C6:C7 =IF(A3/A2=B3/B2,IF(C3/C2=A3/A2,"Infinite","None"),MMULT(MINVERSE(A2:B3),C2:C3))

Excel 2010
	A	B	C
1	x	y
2	-8	-8	12
3	-6	-6	-102
4
5			Solutions
6			None
7			None
Sheet1

 

[andreascostas]

Thank You that works perfectly.