diff options
Diffstat (limited to 'source/text/scalc/01/04060109.xhp')
| -rw-r--r-- | source/text/scalc/01/04060109.xhp | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/source/text/scalc/01/04060109.xhp b/source/text/scalc/01/04060109.xhp index 8c9688f768..109fbb42c2 100644 --- a/source/text/scalc/01/04060109.xhp +++ b/source/text/scalc/01/04060109.xhp @@ -205,13 +205,13 @@ <paragraph xml-lang="en-US" id="par_id3159112" role="paragraph" l10n="U" oldref="56"> <item type="input">=INDEX(Prices;4;1)</item> returns the value from row 4 and column 1 of the database range defined in <emph>Data - Define</emph> as <emph>Prices</emph>.</paragraph> <paragraph xml-lang="en-US" id="par_id3150691" role="paragraph" l10n="U" oldref="57"> - <item type="input">=INDEX(SumX;4;1)</item> returns the value from the range <emph>SumX</emph> in row 4 and column 1 as defined in <emph>Insert - Names - Define</emph>.</paragraph> + <item type="input">=INDEX(SumX;4;1)</item> returns the value from the range <emph>SumX</emph> in row 4 and column 1 as defined in <emph>Sheet - Named Ranges and Expressions - Define</emph>.</paragraph> <paragraph xml-lang="en-US" id="par_id4109012" role="paragraph" l10n="NEW"> <item type="input">=INDEX(A1:B6;1)</item> returns a reference to the first row of A1:B6.</paragraph> <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 - 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> + <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>Sheet - Named Ranges and Expressions - 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"> |