Learn Programming and technology with ease @ developerpublish.com

HomeMicrosoft OfficeExcelMUNIT Function in Excel

# 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

Share:

### You May Also Like

#### SKEW.P Function in Excel

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...

#### SKEW Function in Excel

In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...

#### RANK.EQ Function in Excel

In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
• Excel
• November 23, 2021