mxidentity

1. Syntax:

Return Range  mxidentity(Integer width, Integer height)

Description:

Creates an identity matrix at the location of the current cell with dimensions given by width and height

2. Syntax:

Return Range  mxidentity(Integer width, Integer height, Number scale)

Description:

Creates an identity matrix at the location of the current cell with dimensions given by width and height and a diagonal composed of scale

Examples:

($a1) = mxidentity(4, 3, 2)
AB CD
12000
20200
30020
4
5
6
($a2) = mxidenity(6, 6)