MUNIT Function in Excel

In this post, you will learn about the MUNIT Function in Excel, how to use it in your excel spreadsheets.

MUNIT Function in Excel

This function returns a unit matrix for the given dimension n, which represents n x n the dimension of the matrix.

Syntax

=MUNIT(dimension)

This syntax has one argument

• dimension – This holds the dimension of the function.

How to use MUNIT Function in Excel?

• The function returns a unit matrix with the given dimensions.
• The syntax accepts only positive numbers
• A unit matrix also called an identity matrix is represented with ones in the main diagonal and the remaining places filled with zero’s.
• To start with, highlight the required dimension or the right size and enter the syntax with the dimension.

• To display the answer you must use multi-cell array formula.
• Press Ctrl + Shift +Enter, this will display the answer in a complete matrix form.

Another example with 5 x 5 dimension