Matrix Functions In AFC
Test Sheet
The following test cases reference this sheet:
| A | B | C | D | |
| 1 | 1x1 | 5 (M1x1) |
||
| 2 | ||||
| 3 | 2x2 | 2 | 9 | |
| 4 | 3 | 6 | ||
| 5 | ||||
| 6 | 3x3 | 4 | -3 | 6 |
| 7 | 2 | 5 | -1 | |
| 8 | 7 | 3 | 9 |
B3:C4 (M2x2)
B6:D8 (M3x3)
Matrix Functions
The supported matrix functions are shown by example below:
MDETERM
| B | C | ||
| 11 | 5.0 | =MDETERM( B1 ) | |
| 12 | -15.0 | =MDETERM( B3:C4 ) | |
| 13 | 93.0 | =MDETERM( B6:D8 ) |