Linker IT Software
Order Home
menubar-top-links menubar-top-rechts
SQL*XL: Database to Excel bridge ExcelLock: Lock and secure your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe
Home Products litLIB Help Vector and Matrix functions

Buy now

Download now

LITlib - Excel Power Functions Pack
 
Add-in for Excel that adds additional cell functions to Excel.

litLIB Help - MAdd function
litLIB Help
Product pages :
litLIB
Quick links:
help index
forums

Vector and Matrix - MAdd

Syntax:
= MAdd(Matrix1, Matrix2)

Description:
Matrix addition of two matrices (or vectors)

Matrix1, Matrix2: The two matrices/vectors to be added.

Please ensure that matrix1 and matrix2 are of the same dimensions, the same number of rows and columns. Please also ensure that the result range is of the same dimensions.

MAdd is an array function. Select the block of cells to which you want to add the formula and type the formula in the formula box. Then press Ctrl-Shift-Enter.

Example:
=MAdd(A1:A3,C1:C3)
=MAdd(X10:Z13,X100:Z103)

litLIB