Difference between revisions of "NL/Documentation/How Tos/Calc: functie EENHEIDSMAT"
m |
m |
||
(One intermediate revision by the same user not shown) | |||
Line 1: | Line 1: | ||
+ | {{DISPLAYTITLE:functie EENHEIDSMAT}} | ||
__NOTOC__ | __NOTOC__ | ||
Line 28: | Line 29: | ||
* [[NL/Documentation/How_Tos/Calc: Functies alfabetisch gesorteerd|'''Functies - alfabetisch gesorteerd''']] | * [[NL/Documentation/How_Tos/Calc: Functies alfabetisch gesorteerd|'''Functies - alfabetisch gesorteerd''']] | ||
− | * [[NL/Documentation/How_Tos/Calc: Functies gesorteerd per categorie|'''Functies - gesorteerd per categorie''']] | + | * [[NL/Documentation/How_Tos/Calc: Functies gesorteerd per categorie|'''Functies - gesorteerd per categorie''']]}} |
− | [[Category: NL/Documentation/Reference/Calc]] | + | [[Category:NL/Documentation/Reference/Calc]] |
Latest revision as of 12:38, 3 February 2024
EENHEIDSMAT
Geeft een eenheid (identiteits-)matrix van een bepaalde grootte terug.
Syntaxis:
EENHEIDSMAT(grootte)
- geeft de eenheids-matrix, ook wel de identiteits-matrix I genoemd, van de grootte grootte (een geheel getal groter dan nul).
- De identiteits-matrix heeft enen op de leidende diagonaal en nullen op andere.
- EENHEIDSMAT geeft een matrix terug en moet worden ingevoerd als een matrixformule (bijvoorbeeld door {{#switch:ctrl
| shift = ⇧ Shift
| up = ↑
| down = ↓
| > = →
| < = ←
| enter = ↵ Enter
| cmd = ⌘ Cmd
| command = ⌘ Cmd
| opt = ⌥ Opt
| option = ⌥ Opt
| tab = Tab ⇆
| backspace = ← Backspace
| << = ← Backspace
| bs = ← Backspace
| * = *
| # = #
| ; = ;
| : = :
| #default = Ctrl
}} {{#if:Shift| + {{#switch:shift
| shift = ⇧ Shift
| up = ↑
| down = ↓
| > = →
| < = ←
| enter = ↵ Enter
| cmd = ⌘ Cmd
| command = ⌘ Cmd
| opt = ⌥ Opt
| option = ⌥ Opt
| tab = Tab ⇆
| backspace = ← Backspace
| << = ← Backspace
| bs = ← Backspace
| * = *
| # = #
| ; = ;
| : = :
| #default = Shift
}} }}{{#if:Enter| + {{#switch:enter
| shift = ⇧ Shift
| up = ↑
| down = ↓
| > = →
| < = ←
| enter = ↵ Enter
| cmd = ⌘ Cmd
| command = ⌘ Cmd
| opt = ⌥ Opt
| option = ⌥ Opt
| tab = Tab ⇆
| backspace = ← Backspace
| << = ← Backspace
| bs = ← Backspace
| * = *
| # = #
| ; = ;
| : = :
| #default = Enter
}} }}{{#if:| + {{#switch:{{{4}}}
| shift = ⇧ Shift
| up = ↑
| down = ↓
| > = →
| < = ←
| enter = ↵ Enter
| cmd = ⌘ Cmd
| command = ⌘ Cmd
| opt = ⌥ Opt
| option = ⌥ Opt
| tab = Tab ⇆
| backspace = ← Backspace
| << = ← Backspace
| bs = ← Backspace
| * = *
| # = #
| ; = ;
| : = :
| #default = {{{4}}}
}} }}{{#if:| + {{#switch:{{{5}}}
| shift = ⇧ Shift
| up = ↑
| down = ↓
| > = →
| < = ←
| enter = ↵ Enter
| cmd = ⌘ Cmd
| command = ⌘ Cmd
| opt = ⌥ Opt
| option = ⌥ Opt
| tab = Tab ⇆
| backspace = ← Backspace
| << = ← Backspace
| bs = ← Backspace
| * = *
| # = #
| ; = ;
| : = :
| #default = {{{5}}}
}} }}{{#if:| + {{#switch:{{{6}}}
| shift = ⇧ Shift
| up = ↑
| down = ↓
| > = →
| < = ←
| enter = ↵ Enter
| cmd = ⌘ Cmd
| command = ⌘ Cmd
| opt = ⌥ Opt
| option = ⌥ Opt
| tab = Tab ⇆
| backspace = ← Backspace
| << = ← Backspace
| bs = ← Backspace
| * = *
| # = #
| ; = ;
| : = :
| #default = {{{6}}}
}} }} te gebruiken in plaats van alleen {{#switch:enter
| shift = ⇧ Shift
| up = ↑
| down = ↓
| > = →
| < = ←
| enter = ↵ Enter
| cmd = ⌘ Cmd
| command = ⌘ Cmd
| opt = ⌥ Opt
| option = ⌥ Opt
| tab = Tab ⇆
| backspace = ← Backspace
| << = ← Backspace
| bs = ← Backspace
| * = *
| # = #
| ; = ;
| : = :
| #default = Enter
}} {{#if:| + {{#switch:{{{2}}}
| shift = ⇧ Shift
| up = ↑
| down = ↓
| > = →
| < = ←
| enter = ↵ Enter
| cmd = ⌘ Cmd
| command = ⌘ Cmd
| opt = ⌥ Opt
| option = ⌥ Opt
| tab = Tab ⇆
| backspace = ← Backspace
| << = ← Backspace
| bs = ← Backspace
| * = *
| # = #
| ; = ;
| : = :
| #default = {{{2}}}
}} }}{{#if:| + {{#switch:{{{3}}}
| shift = ⇧ Shift
| up = ↑
| down = ↓
| > = →
| < = ←
| enter = ↵ Enter
| cmd = ⌘ Cmd
| command = ⌘ Cmd
| opt = ⌥ Opt
| option = ⌥ Opt
| tab = Tab ⇆
| backspace = ← Backspace
| << = ← Backspace
| bs = ← Backspace
| * = *
| # = #
| ; = ;
| : = :
| #default = {{{3}}}
}} }}{{#if:| + {{#switch:{{{4}}}
| shift = ⇧ Shift
| up = ↑
| down = ↓
| > = →
| < = ←
| enter = ↵ Enter
| cmd = ⌘ Cmd
| command = ⌘ Cmd
| opt = ⌥ Opt
| option = ⌥ Opt
| tab = Tab ⇆
| backspace = ← Backspace
| << = ← Backspace
| bs = ← Backspace
| * = *
| # = #
| ; = ;
| : = :
| #default = {{{4}}}
}} }}{{#if:| + {{#switch:{{{5}}}
| shift = ⇧ Shift
| up = ↑
| down = ↓
| > = →
| < = ←
| enter = ↵ Enter
| cmd = ⌘ Cmd
| command = ⌘ Cmd
| opt = ⌥ Opt
| option = ⌥ Opt
| tab = Tab ⇆
| backspace = ← Backspace
| << = ← Backspace
| bs = ← Backspace
| * = *
| # = #
| ; = ;
| : = :
| #default = {{{5}}}
}} }}{{#if:| + {{#switch:{{{6}}}
| shift = ⇧ Shift
| up = ↑
| down = ↓
| > = →
| < = ←
| enter = ↵ Enter
| cmd = ⌘ Cmd
| command = ⌘ Cmd
| opt = ⌥ Opt
| option = ⌥ Opt
| tab = Tab ⇆
| backspace = ← Backspace
| << = ← Backspace
| bs = ← Backspace
| * = *
| # = #
| ; = ;
| : = :
| #default = {{{6}}}
}} }}).
Voorbeeld:
=EENHEIDSMAT(2)
- indien ingevoerd als een matrixformule in cel B3, geeft {1;0|0;1} terug, zodat B3, C3, B4 en C4 respectievelijk 1, 0, 0, 1 weergeven.
Zie ook