SheetFX
≡
<< Go back to all functions

MUNIT

The MUNIT function in Google Sheets returns a unit matrix of size dimension x dimension.

Function Syntax and Parameters

Syntax: MUNIT(dimension)

Parameters:

  • dimension: The size of the square unit matrix to be returned.

Step-by-Step Tutorial

  1. Using MUNIT with a dimension of 3:

    • Example: =MUNIT(3)
    • Result:
    1  0  0
0  1  0
0  0  1

  2. Using MUNIT with a dimension of 4:

    • Example: =MUNIT(4)
    • Result:
    1  0  0  0
0  1  0  0
0  0  1  0
0  0  0  1

Use Cases and Scenarios

  1. Linear Algebra: Create identity matrices for matrix operations.
  2. Transformation Matrices: Generate identity matrices for geometric transformations.
  3. Simulations: Create matrices with ones on the diagonal for specific simulations.

Related Articles