GeertD
Board Regular
- Joined
- Dec 22, 2020
- Messages
- 60
- Office Version
- 365
- Platform
- Windows
CONSTANTARRAY: Create an array of the specified dimensions where all cells have the specified constant value.
N.B.: If you want to create a unit matrix instead, use the standard Excel function: MUNIT(n).
N.B.: If you want to create a unit matrix instead, use the standard Excel function: MUNIT(n).
Excel Formula:
=LAMBDA(a,b,val,SEQUENCE(a,b,val,0))| DXLR's LAMBDA.LET Library_v00.07.xlsb | ||||||
|---|---|---|---|---|---|---|
| A | B | C | D | |||
| 1 | 3.14 | 3.14 | 3.14 | |||
| 2 | 3.14 | 3.14 | 3.14 | |||
| 3 | 3.14 | 3.14 | 3.14 | |||
| 4 | ||||||
Sandbox_Mr.Excel | ||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| A1:C3 | A1 | =ConstantArray(3,3,3.14) |
| Dynamic array formulas. | ||
Upvote
0
