MUNIT function

The MUNIT function returns a unit matrix of size dimension x dimension. The result of this function is an array of form:

1 0 …  0

0 1 ... 0 

0 0 … ...

0 0 … 1

Parts of a MUNIT function

MUNIT(dimension)

Part Description
Dimension Required The size of the unit matrix. Dimension must be an integer greater than zero.

Sample formulas

Example 1:  MUNIT(1)

Example 2: MUNIT(3)

Notes

If dimension is less than 1, MUNIT returns a #VALUE error.

Examples

Result for A1=MUNIT(1)

  A
1 1
2  

Result for A1= MUNIT(3)

  A B C
1 1 0 0
2 0 1 0
3 0 0 1

Related functions

  • MMULT: Calculates the matrix product of two matrices specified as arrays or ranges.
  • RANDARRAY: The RANDARRAY function generates an array of random numbers between 0 and 1.
true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu
10393728449108995428
true
Search Help Centre
true
true
true
true
true
35