diff options
| -rw-r--r-- | helpcontent2/source/text/scalc/01/04060109.xhp | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/helpcontent2/source/text/scalc/01/04060109.xhp b/helpcontent2/source/text/scalc/01/04060109.xhp index c7b3bc4227..3e17364ed0 100644 --- a/helpcontent2/source/text/scalc/01/04060109.xhp +++ b/helpcontent2/source/text/scalc/01/04060109.xhp @@ -218,7 +218,7 @@ <paragraph xml-lang="en-US" id="par_id9272133" role="paragraph" l10n="NEW"> <item type="input">=INDEX(A1:B6;0;1)</item> returns a reference to the first column of A1:B6.</paragraph> <paragraph xml-lang="en-US" id="par_id3158419" role="paragraph" l10n="U" oldref="58"> - <item type="input">=INDEX((multi);4;1)</item> indicates the value contained in row 4 and column 1 of the (multiple) range, which you named under <emph>Insert - Names - Set</emph> as <emph>multi</emph>. The multiple range may consist of several rectangular ranges, each with a row 4 and column 1. If you now want to call the second block of this multiple range enter the number <item type="input">2</item> as the <emph>range</emph> parameter.</paragraph> + <item type="input">=INDEX((multi);4;1)</item> indicates the value contained in row 4 and column 1 of the (multiple) range, which you named under <emph>Insert - Names - Define</emph> as <emph>multi</emph>. The multiple range may consist of several rectangular ranges, each with a row 4 and column 1. If you now want to call the second block of this multiple range enter the number <item type="input">2</item> as the <emph>range</emph> parameter.</paragraph> <paragraph xml-lang="en-US" id="par_id3148595" role="paragraph" l10n="U" oldref="59"> <item type="input">=INDEX(A1:B6;1;1)</item> indicates the value in the upper-left of the A1:B6 range.</paragraph> <paragraph xml-lang="en-US" id="par_id9960020" role="paragraph" l10n="NEW"> @@ -624,4 +624,4 @@ <embed href="text/scalc/01/04060100.xhp#drking"/> </section> </body> -</helpdocument>
\ No newline at end of file +</helpdocument> |