Gaussian Elimination

[timberscombe]

Does anyone know how to write a Gaussian Elimination (solving of simultaneous equations) programme on Excel? I havent got a clue about where to start.... please help!!!!

 

[Andrew Poulsom]

Welcome to the Board.

You can use MINVERSE and MMULT, like this:

Book5
	A	B	C	D	E	F
1		x	y	z	Result
2	Equations	-8	1	2	0
3		5	7	-3	10
4		2	1	-2	-2
5	MINVERSE	-0.14865	0.054054	-0.22973	1	x
6		0.054054	0.162162	-0.18919	2	y
7		-0.12162	0.135135	-0.82432	3	z
Sheet1

Sample equations are in B2:E4. The formula in B5:D7 is:

=MINVERSE(B2:D4)

confirmed with Ctrl+Shift +Enter. The formula in E5:E7 is:

=MMULT(B5:D7,E2:E4)

confirmed with Ctrl+Shift +Enter.

 

[tusharm]

There was a recent discussion -- one of several that occur on a regular basis on the subject in one of the XL newsgroups. Search the google.com archives of the newsgroups.

Does anyone know how to write a Gaussian Elimination (solving of simultaneous equations) programme on Excel? I havent got a clue about where to start.... please help!!!!