diff options
| -rw-r--r-- | source/text/scalc/01/04060109.xhp | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/source/text/scalc/01/04060109.xhp b/source/text/scalc/01/04060109.xhp index 0cc5f00312..3f6442c408 100644 --- a/source/text/scalc/01/04060109.xhp +++ b/source/text/scalc/01/04060109.xhp @@ -418,7 +418,7 @@ <item type="input">=OFFSET(B2:C3;1;0;3;4)</item> returns a reference to B2:C3 moved down by one row resized to 3 rows and 4 columns (B3:E5).</paragraph> <paragraph xml-lang="en-US" id="par_id3153739" role="paragraph" l10n="U" oldref="122"> <item type="input">=SUM(OFFSET(A1;2;2;5;6))</item> determines the total of the area that starts in cell C3 and has a height of 5 rows and a width of 6 columns (area=C3:H7).</paragraph> - <paragraph xml-lang="en-US" id="par_id3153740" role="note">If the width or height is included, the OFFSET function returns a range and thus must be entrered as an <link href="text/scalc/01/04060107.xhp">array formula</link>. If both the width and height are missing, a cell reference is returned.</paragraph> + <paragraph xml-lang="en-US" id="par_id3153740" role="note">If the width or height is included, the OFFSET function returns a range and thus must be entered as an <link href="text/scalc/01/04060107.xhp">array formula</link>. If both the width and height are missing, a cell reference is returned.</paragraph> </section> <section id="Section14"> <bookmark xml-lang="en-US" branch="index" id="bm_id3159273"><bookmark_value>LOOKUP function</bookmark_value> |