diff options
| author | Andrea Gelmini <andrea.gelmini@gelma.net> | 2019-09-06 19:43:50 +0200 |
|---|---|---|
| committer | Julien Nabet <serval2412@yahoo.fr> | 2019-09-06 23:21:04 +0200 |
| commit | 85e06dcbee5956f0f25a4d25677fae61206a7195 (patch) | |
| tree | b537f98d97724380eb8c24c974cf58a29ab6d61b /source | |
| parent | b2a9c3b29c29c417574890b27783da777702cabf (diff) | |
Fix typo
Change-Id: I1a9958dedf6b836acef6e1033a9d79f3f94202e0
Reviewed-on: https://gerrit.libreoffice.org/78730
Tested-by: Jenkins
Reviewed-by: Julien Nabet <serval2412@yahoo.fr>
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Diffstat (limited to 'source')
| -rw-r--r-- | source/text/scalc/01/04060106.xhp | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/source/text/scalc/01/04060106.xhp b/source/text/scalc/01/04060106.xhp index c134e8dbb4..7e42bdcb5b 100644 --- a/source/text/scalc/01/04060106.xhp +++ b/source/text/scalc/01/04060106.xhp @@ -1138,7 +1138,7 @@ <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3163656" role="code" xml-lang="en-US">SUM(Number1; Number2; ...; Number30)</paragraph> <paragraph id="par_id3163671" role="paragraph" xml-lang="en-US"><emph>Number1 to Number30</emph> are up to 30 arguments, either cells or ranges, whose sum is to be calculated.</paragraph> -<tip id="par_id151567608802604">SUM ignores any text or empty cell within a range or array. If you suspect wrong results of the SUM function, look for text in the data ranges. Use the <link href="text/scalc/01/03080000.xhp" name="value highllight">value highlighting</link> feature to highlight the text contents in the range that may represent a number.</tip> +<tip id="par_id151567608802604">SUM ignores any text or empty cell within a range or array. If you suspect wrong results of the SUM function, look for text in the data ranges. Use the <link href="text/scalc/01/03080000.xhp" name="value highlight">value highlighting</link> feature to highlight the text contents in the range that may represent a number.</tip> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3163704" role="paragraph" xml-lang="en-US">If you enter the numbers <item type="input">2</item>; <item type="input">3 </item>and <item type="input">4</item> in the Number 1; 2 and 3 text boxes, 9 will be returned as the result.</paragraph> <paragraph id="par_id3151740" role="paragraph" xml-lang="en-US"><item type="input">=SUM(A1;A3;B5)</item> calculates the sum of the three cells. <item type="input">=SUM (A1:E10)</item> calculates the sum of all cells in the A1 to E10 cell range.</paragraph> |