Page 428 - Excel for Scientists and Engineers: Numerical Methods

APPENDIX 3 CUSTOM FUNCTIONS HELP FILE 405

GaussElim
Solves a set of N linear equations in N unknowns by the Gaussian Elimination method.
Returns the array of N unknowns, in either a row or a column, depending on the range
selected by the user.

Syntax
GaussElim (coeff-ma trix,const-vector)
coeff-matrix a reference to an N row x N column array of coefficients
const-vector a reference to an N row x 1 column array of constants

Remarks
The coeff-matrix and the const-vector tables can contain values or formulas.
The GaussElim function is an array function. You can select either a 1 row x N
column horizontal range of cells or an N row x 1 column vertical range of cells,
enter the function and then press CONTROL+SHIR+ENTER (Windows) or
COMMAND+RETURN or CONTROL+SHIFT+RETURN (Macintosh).

See Also
Gausslordanl, GaussJordanZ, GaussSeidel, SimultEqNL