Blockpad arrays perform typical matrix math operations, including multiplication and inverses.
Create an array
Square brackets begin and end an array. Commas separate items in a row and semi-colons designate the end of a row.
Array from a spreadsheet
You can also create an array by referencing cells in a spreadsheet table.
Use the normal math operators for matrix math, like + and *.
Addition and subtraction
To find the inverse of a matrix, you can use the Inverse() function or raise the matrix to the negative 1.
Arrays as spreadsheet range
Arrays act essentially the same as spreadsheet ranges, so you can use functions on them like Sum(), Max(), or even Vlookup().
You can also include text and other kinds of values. Learn more in the deep dive guide.
Display array in a spreadsheet
You can display an array in spreadsheet form. If a formula results in an array while in a spreadsheet, press ctr+shift+enter, and it will fill the cells below and to the right.