[Libreoffice-commits] help.git: Branch 'libreoffice-6-1' - source/media source/text
Olivier Hallot
olivier.hallot at libreoffice.org
Sat Jun 23 11:03:04 UTC 2018
source/media/files/scalc/am/functions_ifs.ods |binary
source/media/files/scalc/ar/functions_ifs.ods |binary
source/media/files/scalc/ast/functions_ifs.ods |binary
source/media/files/scalc/bg/functions_ifs.ods |binary
source/media/files/scalc/bn-IN/functions_ifs.ods |binary
source/media/files/scalc/bn/functions_ifs.ods |binary
source/media/files/scalc/bo/functions_ifs.ods |binary
source/media/files/scalc/bs/functions_ifs.ods |binary
source/media/files/scalc/ca-valencia/functions_ifs.ods |binary
source/media/files/scalc/ca/functions_ifs.ods |binary
source/media/files/scalc/cs/functions_ifs.ods |binary
source/media/files/scalc/da/functions_ifs.ods |binary
source/media/files/scalc/de/functions_ifs.ods |binary
source/media/files/scalc/dz/functions_ifs.ods |binary
source/media/files/scalc/el/functions_ifs.ods |binary
source/media/files/scalc/en-GB/functions_ifs.ods |binary
source/media/files/scalc/en-US/functions_ifs.ods |binary
source/media/files/scalc/en-ZA/functions_ifs.ods |binary
source/media/files/scalc/eo/functions_ifs.ods |binary
source/media/files/scalc/es/functions_ifs.ods |binary
source/media/files/scalc/et/functions_ifs.ods |binary
source/media/files/scalc/eu/functions_ifs.ods |binary
source/media/files/scalc/fi/functions_ifs.ods |binary
source/media/files/scalc/fr/functions_ifs.ods |binary
source/media/files/scalc/functions_ifs.ods |binary
source/media/files/scalc/gl/functions_ifs.ods |binary
source/media/files/scalc/gu/functions_ifs.ods |binary
source/media/files/scalc/he/functions_ifs.ods |binary
source/media/files/scalc/hi/functions_ifs.ods |binary
source/media/files/scalc/hr/functions_ifs.ods |binary
source/media/files/scalc/hu/functions_ifs.ods |binary
source/media/files/scalc/id/functions_ifs.ods |binary
source/media/files/scalc/is/functions_ifs.ods |binary
source/media/files/scalc/it/functions_ifs.ods |binary
source/media/files/scalc/ja/functions_ifs.ods |binary
source/media/files/scalc/ka/functions_ifs.ods |binary
source/media/files/scalc/km/functions_ifs.ods |binary
source/media/files/scalc/ko/functions_ifs.ods |binary
source/media/files/scalc/lo/functions_ifs.ods |binary
source/media/files/scalc/lt/functions_ifs.ods |binary
source/media/files/scalc/lv/functions_ifs.ods |binary
source/media/files/scalc/mk/functions_ifs.ods |binary
source/media/files/scalc/nb/functions_ifs.ods |binary
source/media/files/scalc/ne/functions_ifs.ods |binary
source/media/files/scalc/nl/functions_ifs.ods |binary
source/media/files/scalc/nn/functions_ifs.ods |binary
source/media/files/scalc/om/functions_ifs.ods |binary
source/media/files/scalc/pl/functions_ifs.ods |binary
source/media/files/scalc/pt-BR/functions_ifs.ods |binary
source/media/files/scalc/pt/functions_ifs.ods |binary
source/media/files/scalc/qtz/functions_ifs.ods |binary
source/media/files/scalc/ro/functions_ifs.ods |binary
source/media/files/scalc/ru/functions_ifs.ods |binary
source/media/files/scalc/si/functions_ifs.ods |binary
source/media/files/scalc/sid/functions_ifs.ods |binary
source/media/files/scalc/sk/functions_ifs.ods |binary
source/media/files/scalc/sl/functions_ifs.ods |binary
source/media/files/scalc/sq/functions_ifs.ods |binary
source/media/files/scalc/sv/functions_ifs.ods |binary
source/media/files/scalc/ta/functions_ifs.ods |binary
source/media/files/scalc/tg/functions_ifs.ods |binary
source/media/files/scalc/tr/functions_ifs.ods |binary
source/media/files/scalc/ug/functions_ifs.ods |binary
source/media/files/scalc/uk/functions_ifs.ods |binary
source/media/files/scalc/vi/functions_ifs.ods |binary
source/media/files/scalc/zh-CN/functions_ifs.ods |binary
source/media/files/scalc/zh-TW/functions_ifs.ods |binary
source/text/scalc/01/04060106.xhp | 4 +--
source/text/scalc/01/04060181.xhp | 8 +++----
source/text/scalc/01/04060184.xhp | 16 +++++++--------
source/text/scalc/01/func_averageif.xhp | 13 +++++++++++-
source/text/scalc/01/func_averageifs.xhp | 17 ++++++++++++++--
source/text/scalc/01/func_countifs.xhp | 14 ++++++++++++-
source/text/scalc/01/func_maxifs.xhp | 17 ++++++++++++++--
source/text/scalc/01/func_minifs.xhp | 18 +++++++++++++++--
source/text/scalc/01/func_sumifs.xhp | 14 +++++++++++--
76 files changed, 97 insertions(+), 24 deletions(-)
New commits:
commit e7e056ade1c2aa65aa7d1b9e6453735011886707
Author: Olivier Hallot <olivier.hallot at libreoffice.org>
Date: Fri Jun 22 23:32:13 2018 -0300
Improve 'IFS documentation
COUNTIFS, SUMIFS, AVERAGEIFS, MAXIFS, MINIFS
Improve collateral file
Change-Id: I0573b4df1b7fdc5b656100756e98468bc2a0edf7
Reviewed-on: https://gerrit.libreoffice.org/56311
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot at libreoffice.org>
diff --git a/source/media/files/scalc/am/functions_ifs.ods b/source/media/files/scalc/am/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/am/functions_ifs.ods and b/source/media/files/scalc/am/functions_ifs.ods differ
diff --git a/source/media/files/scalc/ar/functions_ifs.ods b/source/media/files/scalc/ar/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/ar/functions_ifs.ods and b/source/media/files/scalc/ar/functions_ifs.ods differ
diff --git a/source/media/files/scalc/ast/functions_ifs.ods b/source/media/files/scalc/ast/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/ast/functions_ifs.ods and b/source/media/files/scalc/ast/functions_ifs.ods differ
diff --git a/source/media/files/scalc/bg/functions_ifs.ods b/source/media/files/scalc/bg/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/bg/functions_ifs.ods and b/source/media/files/scalc/bg/functions_ifs.ods differ
diff --git a/source/media/files/scalc/bn-IN/functions_ifs.ods b/source/media/files/scalc/bn-IN/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/bn-IN/functions_ifs.ods and b/source/media/files/scalc/bn-IN/functions_ifs.ods differ
diff --git a/source/media/files/scalc/bn/functions_ifs.ods b/source/media/files/scalc/bn/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/bn/functions_ifs.ods and b/source/media/files/scalc/bn/functions_ifs.ods differ
diff --git a/source/media/files/scalc/bo/functions_ifs.ods b/source/media/files/scalc/bo/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/bo/functions_ifs.ods and b/source/media/files/scalc/bo/functions_ifs.ods differ
diff --git a/source/media/files/scalc/bs/functions_ifs.ods b/source/media/files/scalc/bs/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/bs/functions_ifs.ods and b/source/media/files/scalc/bs/functions_ifs.ods differ
diff --git a/source/media/files/scalc/ca-valencia/functions_ifs.ods b/source/media/files/scalc/ca-valencia/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/ca-valencia/functions_ifs.ods and b/source/media/files/scalc/ca-valencia/functions_ifs.ods differ
diff --git a/source/media/files/scalc/ca/functions_ifs.ods b/source/media/files/scalc/ca/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/ca/functions_ifs.ods and b/source/media/files/scalc/ca/functions_ifs.ods differ
diff --git a/source/media/files/scalc/cs/functions_ifs.ods b/source/media/files/scalc/cs/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/cs/functions_ifs.ods and b/source/media/files/scalc/cs/functions_ifs.ods differ
diff --git a/source/media/files/scalc/da/functions_ifs.ods b/source/media/files/scalc/da/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/da/functions_ifs.ods and b/source/media/files/scalc/da/functions_ifs.ods differ
diff --git a/source/media/files/scalc/de/functions_ifs.ods b/source/media/files/scalc/de/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/de/functions_ifs.ods and b/source/media/files/scalc/de/functions_ifs.ods differ
diff --git a/source/media/files/scalc/dz/functions_ifs.ods b/source/media/files/scalc/dz/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/dz/functions_ifs.ods and b/source/media/files/scalc/dz/functions_ifs.ods differ
diff --git a/source/media/files/scalc/el/functions_ifs.ods b/source/media/files/scalc/el/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/el/functions_ifs.ods and b/source/media/files/scalc/el/functions_ifs.ods differ
diff --git a/source/media/files/scalc/en-GB/functions_ifs.ods b/source/media/files/scalc/en-GB/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/en-GB/functions_ifs.ods and b/source/media/files/scalc/en-GB/functions_ifs.ods differ
diff --git a/source/media/files/scalc/en-US/functions_ifs.ods b/source/media/files/scalc/en-US/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/en-US/functions_ifs.ods and b/source/media/files/scalc/en-US/functions_ifs.ods differ
diff --git a/source/media/files/scalc/en-ZA/functions_ifs.ods b/source/media/files/scalc/en-ZA/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/en-ZA/functions_ifs.ods and b/source/media/files/scalc/en-ZA/functions_ifs.ods differ
diff --git a/source/media/files/scalc/eo/functions_ifs.ods b/source/media/files/scalc/eo/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/eo/functions_ifs.ods and b/source/media/files/scalc/eo/functions_ifs.ods differ
diff --git a/source/media/files/scalc/es/functions_ifs.ods b/source/media/files/scalc/es/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/es/functions_ifs.ods and b/source/media/files/scalc/es/functions_ifs.ods differ
diff --git a/source/media/files/scalc/et/functions_ifs.ods b/source/media/files/scalc/et/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/et/functions_ifs.ods and b/source/media/files/scalc/et/functions_ifs.ods differ
diff --git a/source/media/files/scalc/eu/functions_ifs.ods b/source/media/files/scalc/eu/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/eu/functions_ifs.ods and b/source/media/files/scalc/eu/functions_ifs.ods differ
diff --git a/source/media/files/scalc/fi/functions_ifs.ods b/source/media/files/scalc/fi/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/fi/functions_ifs.ods and b/source/media/files/scalc/fi/functions_ifs.ods differ
diff --git a/source/media/files/scalc/fr/functions_ifs.ods b/source/media/files/scalc/fr/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/fr/functions_ifs.ods and b/source/media/files/scalc/fr/functions_ifs.ods differ
diff --git a/source/media/files/scalc/functions_ifs.ods b/source/media/files/scalc/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/functions_ifs.ods and b/source/media/files/scalc/functions_ifs.ods differ
diff --git a/source/media/files/scalc/gl/functions_ifs.ods b/source/media/files/scalc/gl/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/gl/functions_ifs.ods and b/source/media/files/scalc/gl/functions_ifs.ods differ
diff --git a/source/media/files/scalc/gu/functions_ifs.ods b/source/media/files/scalc/gu/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/gu/functions_ifs.ods and b/source/media/files/scalc/gu/functions_ifs.ods differ
diff --git a/source/media/files/scalc/he/functions_ifs.ods b/source/media/files/scalc/he/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/he/functions_ifs.ods and b/source/media/files/scalc/he/functions_ifs.ods differ
diff --git a/source/media/files/scalc/hi/functions_ifs.ods b/source/media/files/scalc/hi/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/hi/functions_ifs.ods and b/source/media/files/scalc/hi/functions_ifs.ods differ
diff --git a/source/media/files/scalc/hr/functions_ifs.ods b/source/media/files/scalc/hr/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/hr/functions_ifs.ods and b/source/media/files/scalc/hr/functions_ifs.ods differ
diff --git a/source/media/files/scalc/hu/functions_ifs.ods b/source/media/files/scalc/hu/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/hu/functions_ifs.ods and b/source/media/files/scalc/hu/functions_ifs.ods differ
diff --git a/source/media/files/scalc/id/functions_ifs.ods b/source/media/files/scalc/id/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/id/functions_ifs.ods and b/source/media/files/scalc/id/functions_ifs.ods differ
diff --git a/source/media/files/scalc/is/functions_ifs.ods b/source/media/files/scalc/is/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/is/functions_ifs.ods and b/source/media/files/scalc/is/functions_ifs.ods differ
diff --git a/source/media/files/scalc/it/functions_ifs.ods b/source/media/files/scalc/it/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/it/functions_ifs.ods and b/source/media/files/scalc/it/functions_ifs.ods differ
diff --git a/source/media/files/scalc/ja/functions_ifs.ods b/source/media/files/scalc/ja/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/ja/functions_ifs.ods and b/source/media/files/scalc/ja/functions_ifs.ods differ
diff --git a/source/media/files/scalc/ka/functions_ifs.ods b/source/media/files/scalc/ka/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/ka/functions_ifs.ods and b/source/media/files/scalc/ka/functions_ifs.ods differ
diff --git a/source/media/files/scalc/km/functions_ifs.ods b/source/media/files/scalc/km/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/km/functions_ifs.ods and b/source/media/files/scalc/km/functions_ifs.ods differ
diff --git a/source/media/files/scalc/ko/functions_ifs.ods b/source/media/files/scalc/ko/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/ko/functions_ifs.ods and b/source/media/files/scalc/ko/functions_ifs.ods differ
diff --git a/source/media/files/scalc/lo/functions_ifs.ods b/source/media/files/scalc/lo/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/lo/functions_ifs.ods and b/source/media/files/scalc/lo/functions_ifs.ods differ
diff --git a/source/media/files/scalc/lt/functions_ifs.ods b/source/media/files/scalc/lt/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/lt/functions_ifs.ods and b/source/media/files/scalc/lt/functions_ifs.ods differ
diff --git a/source/media/files/scalc/lv/functions_ifs.ods b/source/media/files/scalc/lv/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/lv/functions_ifs.ods and b/source/media/files/scalc/lv/functions_ifs.ods differ
diff --git a/source/media/files/scalc/mk/functions_ifs.ods b/source/media/files/scalc/mk/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/mk/functions_ifs.ods and b/source/media/files/scalc/mk/functions_ifs.ods differ
diff --git a/source/media/files/scalc/nb/functions_ifs.ods b/source/media/files/scalc/nb/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/nb/functions_ifs.ods and b/source/media/files/scalc/nb/functions_ifs.ods differ
diff --git a/source/media/files/scalc/ne/functions_ifs.ods b/source/media/files/scalc/ne/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/ne/functions_ifs.ods and b/source/media/files/scalc/ne/functions_ifs.ods differ
diff --git a/source/media/files/scalc/nl/functions_ifs.ods b/source/media/files/scalc/nl/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/nl/functions_ifs.ods and b/source/media/files/scalc/nl/functions_ifs.ods differ
diff --git a/source/media/files/scalc/nn/functions_ifs.ods b/source/media/files/scalc/nn/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/nn/functions_ifs.ods and b/source/media/files/scalc/nn/functions_ifs.ods differ
diff --git a/source/media/files/scalc/om/functions_ifs.ods b/source/media/files/scalc/om/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/om/functions_ifs.ods and b/source/media/files/scalc/om/functions_ifs.ods differ
diff --git a/source/media/files/scalc/pl/functions_ifs.ods b/source/media/files/scalc/pl/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/pl/functions_ifs.ods and b/source/media/files/scalc/pl/functions_ifs.ods differ
diff --git a/source/media/files/scalc/pt-BR/functions_ifs.ods b/source/media/files/scalc/pt-BR/functions_ifs.ods
index 93e43e201..f1857045f 100644
Binary files a/source/media/files/scalc/pt-BR/functions_ifs.ods and b/source/media/files/scalc/pt-BR/functions_ifs.ods differ
diff --git a/source/media/files/scalc/pt/functions_ifs.ods b/source/media/files/scalc/pt/functions_ifs.ods
index 93e43e201..0792b5e6a 100644
Binary files a/source/media/files/scalc/pt/functions_ifs.ods and b/source/media/files/scalc/pt/functions_ifs.ods differ
diff --git a/source/media/files/scalc/qtz/functions_ifs.ods b/source/media/files/scalc/qtz/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/qtz/functions_ifs.ods and b/source/media/files/scalc/qtz/functions_ifs.ods differ
diff --git a/source/media/files/scalc/ro/functions_ifs.ods b/source/media/files/scalc/ro/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/ro/functions_ifs.ods and b/source/media/files/scalc/ro/functions_ifs.ods differ
diff --git a/source/media/files/scalc/ru/functions_ifs.ods b/source/media/files/scalc/ru/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/ru/functions_ifs.ods and b/source/media/files/scalc/ru/functions_ifs.ods differ
diff --git a/source/media/files/scalc/si/functions_ifs.ods b/source/media/files/scalc/si/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/si/functions_ifs.ods and b/source/media/files/scalc/si/functions_ifs.ods differ
diff --git a/source/media/files/scalc/sid/functions_ifs.ods b/source/media/files/scalc/sid/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/sid/functions_ifs.ods and b/source/media/files/scalc/sid/functions_ifs.ods differ
diff --git a/source/media/files/scalc/sk/functions_ifs.ods b/source/media/files/scalc/sk/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/sk/functions_ifs.ods and b/source/media/files/scalc/sk/functions_ifs.ods differ
diff --git a/source/media/files/scalc/sl/functions_ifs.ods b/source/media/files/scalc/sl/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/sl/functions_ifs.ods and b/source/media/files/scalc/sl/functions_ifs.ods differ
diff --git a/source/media/files/scalc/sq/functions_ifs.ods b/source/media/files/scalc/sq/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/sq/functions_ifs.ods and b/source/media/files/scalc/sq/functions_ifs.ods differ
diff --git a/source/media/files/scalc/sv/functions_ifs.ods b/source/media/files/scalc/sv/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/sv/functions_ifs.ods and b/source/media/files/scalc/sv/functions_ifs.ods differ
diff --git a/source/media/files/scalc/ta/functions_ifs.ods b/source/media/files/scalc/ta/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/ta/functions_ifs.ods and b/source/media/files/scalc/ta/functions_ifs.ods differ
diff --git a/source/media/files/scalc/tg/functions_ifs.ods b/source/media/files/scalc/tg/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/tg/functions_ifs.ods and b/source/media/files/scalc/tg/functions_ifs.ods differ
diff --git a/source/media/files/scalc/tr/functions_ifs.ods b/source/media/files/scalc/tr/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/tr/functions_ifs.ods and b/source/media/files/scalc/tr/functions_ifs.ods differ
diff --git a/source/media/files/scalc/ug/functions_ifs.ods b/source/media/files/scalc/ug/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/ug/functions_ifs.ods and b/source/media/files/scalc/ug/functions_ifs.ods differ
diff --git a/source/media/files/scalc/uk/functions_ifs.ods b/source/media/files/scalc/uk/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/uk/functions_ifs.ods and b/source/media/files/scalc/uk/functions_ifs.ods differ
diff --git a/source/media/files/scalc/vi/functions_ifs.ods b/source/media/files/scalc/vi/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/vi/functions_ifs.ods and b/source/media/files/scalc/vi/functions_ifs.ods differ
diff --git a/source/media/files/scalc/zh-CN/functions_ifs.ods b/source/media/files/scalc/zh-CN/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/zh-CN/functions_ifs.ods and b/source/media/files/scalc/zh-CN/functions_ifs.ods differ
diff --git a/source/media/files/scalc/zh-TW/functions_ifs.ods b/source/media/files/scalc/zh-TW/functions_ifs.ods
index 93e43e201..f20937c84 100644
Binary files a/source/media/files/scalc/zh-TW/functions_ifs.ods and b/source/media/files/scalc/zh-TW/functions_ifs.ods differ
diff --git a/source/text/scalc/01/04060106.xhp b/source/text/scalc/01/04060106.xhp
index 08c0ffc7e..297f91c12 100644
--- a/source/text/scalc/01/04060106.xhp
+++ b/source/text/scalc/01/04060106.xhp
@@ -1122,7 +1122,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SUMME" id="bm_id3163608" localize="false"/>
-<paragraph id="hd_id3163596" role="heading" level="2" xml-lang="en-US">SUM</paragraph>
+<paragraph id="hd_id3163596" role="heading" level="2" xml-lang="en-US"><variable id="sum_head"><link href="text/scalc/01/04060106.xhp#Section16">SUM</link></variable></paragraph>
<paragraph id="par_id3163625" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_SUMME">Adds all the numbers in a range of cells.</ahelp></paragraph>
<paragraph id="hd_id3163643" role="heading" level="3" xml-lang="en-US">Syntax</paragraph>
@@ -1150,7 +1150,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SUMMEWENN" id="bm_id3151969" localize="false"/>
-<paragraph id="hd_id3151957" role="heading" level="2" xml-lang="en-US">SUMIF</paragraph>
+<paragraph id="hd_id3151957" role="heading" level="2" xml-lang="en-US"><variable id="sumif_head"><link href="text/scalc/01/04060106.xhp#Section15">SUMIF</link></variable></paragraph>
<paragraph id="par_id3151986" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_SUMMEWENN">Adds the cells specified by a given criteria.</ahelp> This function is used to browse a range when you search for a certain value.</paragraph>
<embed href="text/shared/00/00000001.xhp#regulaer"/>
diff --git a/source/text/scalc/01/04060181.xhp b/source/text/scalc/01/04060181.xhp
index 1909e4b56..df8f67f53 100644
--- a/source/text/scalc/01/04060181.xhp
+++ b/source/text/scalc/01/04060181.xhp
@@ -62,7 +62,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ANZAHL" id="bm_id3153040" localize="false"/>
-<paragraph id="hd_id3148437" role="heading" level="2" xml-lang="en-US">COUNT</paragraph>
+<paragraph id="hd_id3148437" role="heading" level="2" xml-lang="en-US"><variable id="count_head"><link href="text/scalc/01/04060181.xhp#count">COUNT</link></variable></paragraph>
<paragraph id="par_id3150700" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ANZAHL">Counts how many numbers are in the list of arguments.</ahelp> Text entries are ignored.</paragraph>
<paragraph id="hd_id3153930" role="heading" level="3" xml-lang="en-US">Syntax</paragraph>
@@ -82,7 +82,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ANZAHL2" id="bm_id3148738" localize="false"/>
-<paragraph id="hd_id3149729" role="heading" level="2" xml-lang="en-US">COUNTA</paragraph>
+<paragraph id="hd_id3149729" role="heading" level="2" xml-lang="en-US"><variable id="counta_head"><link href="text/scalc/01/04060181.xhp#counta">COUNTA</link></variable></paragraph>
<paragraph id="par_id3150142" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ANZAHL2">Counts how many values are in the list of arguments.</ahelp> Text entries are also counted, even when they contain an empty string of length 0. If an argument is an array or reference, empty cells within the array or reference are ignored.<comment>UFI: fix to #i35888#</comment></paragraph>
<paragraph id="hd_id3148573" role="heading" level="3" xml-lang="en-US">Syntax</paragraph>
@@ -103,7 +103,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ANZAHLLEEREZELLEN" id="bm_id3149730" localize="false"/>
-<paragraph id="hd_id3150896" role="heading" level="2" xml-lang="en-US">COUNTBLANK</paragraph>
+<paragraph id="hd_id3150896" role="heading" level="2" xml-lang="en-US"><variable id="countblank_head"><link href="text/scalc/01/04060181.xhp#countblank">COUNTBLANK</link></variable></paragraph>
<paragraph id="par_id3155260" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ANZAHLLEEREZELLEN">Returns the number of empty cells.</ahelp></paragraph>
<paragraph id="hd_id3145144" role="heading" level="3" xml-lang="en-US">Syntax</paragraph>
@@ -122,7 +122,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ZAEHLENWENN" id="bm_id3164909" localize="false"/>
-<paragraph id="hd_id3164897" role="heading" level="2" xml-lang="en-US">COUNTIF</paragraph>
+<paragraph id="hd_id3164897" role="heading" level="2" xml-lang="en-US"><variable id="countif_head"><link href="text/scalc/01/04060181.xhp#countif">COUNTIF</link></variable></paragraph>
<paragraph id="par_id3164926" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ZAEHLENWENN">Returns the number of cells that meet with certain criteria within a cell range.</ahelp></paragraph>
<embed href="text/shared/00/00000001.xhp#regulaer"/>
diff --git a/source/text/scalc/01/04060184.xhp b/source/text/scalc/01/04060184.xhp
index fd6dc0ece..bd85e3443 100644
--- a/source/text/scalc/01/04060184.xhp
+++ b/source/text/scalc/01/04060184.xhp
@@ -34,7 +34,7 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3154511"><bookmark_value>MAX function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MAX" id="bm_id3146972" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3154511" role="heading" level="2">MAX</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3154511" role="heading" level="2"><variable id="max_head"><link href="text/scalc/01/04060184.xhp#max">MAX</link></variable></paragraph>
<paragraph xml-lang="en-US" id="par_id3153709" role="paragraph"><ahelp hid="HID_FUNC_MAX">Returns the maximum value in a list of arguments.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="par_id9282509" role="paragraph">Returns 0 if no numeric value and no error was encountered in the cell range(s) passed as cell reference(s). Text cells are ignored by MIN() and MAX(). The functions MINA() and MAXA() return 0 if no value (numeric or text) and no error was encountered. Passing a literal string argument to MIN() or MAX(), e.g. MIN("string"), still results in an error.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3154256" role="heading" level="3">Syntax</paragraph>
@@ -50,7 +50,7 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3166426"><bookmark_value>MAXA function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MAXA" id="bm_id3150304" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3166426" role="heading" level="2">MAXA</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3166426" role="heading" level="2"><variable id="maxa_head"><link href="text/scalc/01/04060184.xhp#maxa">MAXA</link></variable></paragraph>
<paragraph xml-lang="en-US" id="par_id3150363" role="paragraph"><ahelp hid="HID_FUNC_MAXA">Returns the maximum value in a list of arguments. In opposite to MAX, here you can enter text. The value of the text is 0.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="par_id7689443" role="paragraph">The functions MINA() and MAXA() return 0 if no value (numeric or text) and no error was encountered.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3150516" role="heading" level="3">Syntax</paragraph>
@@ -66,7 +66,7 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3153820"><bookmark_value>MEDIAN function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MEDIAN" id="bm_id3153069" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3153820" role="heading" level="2">MEDIAN</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3153820" role="heading" level="2"><variable id="median_head"><link href="text/scalc/01/04060184.xhp#median">MEDIAN</link></variable></paragraph>
<paragraph xml-lang="en-US" id="par_id3151241" role="paragraph"><ahelp hid="HID_FUNC_MEDIAN">Returns the median of a set of numbers. In a set containing an uneven number of values, the median will be the number in the middle of the set and in a set containing an even number of values, it will be the mean of the two values in the middle of the set.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="hd_id3148871" role="heading" level="3">Syntax</paragraph>
<paragraph xml-lang="en-US" id="par_id3155264" role="code">MEDIAN(Number1; Number2; ...; Number30)</paragraph>
@@ -79,7 +79,7 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3154541"><bookmark_value>MIN function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MIN" id="bm_id3159226" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3154541" role="heading" level="2">MIN</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3154541" role="heading" level="2"><variable id="min_head"><link href="text/scalc/01/04060184.xhp#min">MIN</link></variable></paragraph>
<paragraph xml-lang="en-US" id="par_id3143222" role="paragraph"><ahelp hid="HID_FUNC_MIN">Returns the minimum value in a list of arguments.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="par_id2301400" role="paragraph">Returns 0 if no numeric value and no error was encountered in the cell range(s) passed as cell reference(s). Text cells are ignored by MIN() and MAX(). The functions MINA() and MAXA() return 0 if no value (numeric or text) and no error was encountered. Passing a literal string argument to MIN() or MAX(), e.g. MIN("string"), still results in an error.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3154651" role="heading" level="3">Syntax</paragraph>
@@ -93,7 +93,7 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3147504"><bookmark_value>MINA function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MINA" id="bm_id3155752" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3147504" role="heading" level="2">MINA</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3147504" role="heading" level="2"><variable id="mina_head"><link href="text/scalc/01/04060184.xhp#mina">MINA</link></variable></paragraph>
<paragraph xml-lang="en-US" id="par_id3147249" role="paragraph"><ahelp hid="HID_FUNC_MINA">Returns the minimum value in a list of arguments. Here you can also enter text. The value of the text is 0.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="par_id4294564" role="paragraph">The functions MINA() and MAXA() return 0 if no value (numeric or text) and no error was encountered.</paragraph>
<paragraph xml-lang="en-US" id="hd_id3150435" role="heading" level="3">Syntax</paragraph>
@@ -110,7 +110,7 @@
<bookmark_value>averages;statistical functions</bookmark_value>
</bookmark><comment>mw added "averages;"</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MITTELABW" id="bm_id3156396" localize="false"/>
-<paragraph role="heading" id="hd_id3166465" xml-lang="en-US" level="2">AVEDEV</paragraph>
+<paragraph role="heading" id="hd_id3166465" xml-lang="en-US" level="2"><variable id="avedev_head"><link href="text/scalc/01/04060184.xhp#avedev">AVEDEV</link></variable></paragraph>
<paragraph role="paragraph" id="par_id3150373" xml-lang="en-US"><ahelp hid="HID_FUNC_MITTELABW">Returns the average of the absolute deviations of data points from their mean.</ahelp> Displays the diffusion in a data set.</paragraph>
<paragraph role="heading" id="hd_id3150038" xml-lang="en-US" level="3">Syntax</paragraph>
<paragraph role="code" id="par_id3145636" xml-lang="en-US">AVEDEV(Number1; Number2; ...; Number30)</paragraph>
@@ -124,7 +124,7 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3145824"><bookmark_value>AVERAGE function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MITTELWERT" id="bm_id3146878" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3145824" role="heading" level="2">AVERAGE</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3145824" role="heading" level="2"><variable id="average_head"><link href="text/scalc/01/04060184.xhp#average">AVERAGE</link></variable></paragraph>
<paragraph xml-lang="en-US" id="par_id3150482" role="paragraph"><ahelp hid="HID_FUNC_MITTELWERT">Returns the average of the arguments.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="hd_id3146943" role="heading" level="3">Syntax</paragraph>
<paragraph xml-lang="en-US" id="par_id3154679" role="code">AVERAGE(Number1; Number2; ...; Number30)</paragraph>
@@ -138,7 +138,7 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3148754"><bookmark_value>AVERAGEA function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MITTELWERTA" id="bm_id3149690" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3148754" role="heading" level="2">AVERAGEA</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3148754" role="heading" level="2"><variable id="averagea_head"><link href="text/scalc/01/04060184.xhp#averagea">AVERAGEA</link></variable></paragraph>
<paragraph xml-lang="en-US" id="par_id3145138" role="paragraph"><ahelp hid="HID_FUNC_MITTELWERTA">Returns the average of the arguments. The value of a text is 0.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="hd_id3153326" role="heading" level="3">Syntax</paragraph>
<paragraph xml-lang="en-US" id="par_id3149734" role="code">AVERAGEA(Value1; Value2; ...; Value30)</paragraph>
diff --git a/source/text/scalc/01/func_averageif.xhp b/source/text/scalc/01/func_averageif.xhp
index ed548b2d8..fc30cc190 100644
--- a/source/text/scalc/01/func_averageif.xhp
+++ b/source/text/scalc/01/func_averageif.xhp
@@ -65,7 +65,18 @@ If the whole range is empty, contains only text or all values of the range do no
<paragraph id="par_id316901523627285" role="paragraph" xml-lang="en-US"><item type="input">=AVERAGEIF(B2:B6;"<"&E2;C2:C6)</item></paragraph>
<paragraph id="par_id302181300528607" role="paragraph" xml-lang="en-US">The function searches what cells from the range B2:B6 are less than the value specified in E2, and calculates the average of corresponding values from the C2:C6 range. If E2 = 35, the function returns 145.</paragraph>
<section id="relatedtopics">
-<paragraph id="par_id171371269326270" role="paragraph" xml-lang="en-US"><link href="text/scalc/01/04060184.xhp#average">AVERAGE</link>, <link href="text/scalc/01/04060184.xhp#averagea">AVERAGEA</link>, <embedvar href="text/scalc/01/func_averageifs.xhp#averageifs_head"/>, <link href="text/scalc/01/04060184.xhp#max">MAX</link>, <link href="text/scalc/01/04060184.xhp#min">MIN</link>, <link href="text/scalc/01/04060183.xhp#large">LARGE</link>, <link href="text/scalc/01/04060183.xhp#small">SMALL</link></paragraph>
+ <paragraph id="par_id11921178730928" role="paragraph" xml-lang="en-US" localize="false">
+ <embedvar href="text/scalc/01/04060184.xhp#average_head"/>,
+ <embedvar href="text/scalc/01/04060184.xhp#averagea_head"/>,
+ <embedvar href="text/scalc/01/04060184.xhp#avedev_head"/>
+ </paragraph>
+ <paragraph id="par_id11931178730928" role="paragraph" xml-lang="en-US" localize="false">
+ <embedvar href="text/scalc/01/func_countifs.xhp#countifs_head"/>,
+ <embedvar href="text/scalc/01/func_minifs.xhp#minifs_head"/>,
+ <embedvar href="text/scalc/01/func_maxifs.xhp#maxifs_head"/>,
+ <embedvar href="text/scalc/01/func_averageifs.xhp#averageifs_head"/>,
+ <embedvar href="text/scalc/01/func_sumifs.xhp#sumifs_head"/>
+ </paragraph>
<paragraph id="par_id251321802714497" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/shared/01/02100001.xhp#02100001"/></paragraph>
</section>
</body>
diff --git a/source/text/scalc/01/func_averageifs.xhp b/source/text/scalc/01/func_averageifs.xhp
index 6a38f4e4d..cd6be6eab 100644
--- a/source/text/scalc/01/func_averageifs.xhp
+++ b/source/text/scalc/01/func_averageifs.xhp
@@ -51,9 +51,22 @@
<paragraph id="par_id316794795433" role="paragraph" xml-lang="en-US">If you need to change a criterion easily, you may want to specify it in a separate cell and use a reference to this cell in the condition of AVERAGEIFS function. For example, the above function can be rewritten as follows:</paragraph>
<paragraph id="par_id67531072426731" role="paragraph" xml-lang="en-US"><item type="input">=AVERAGEIFS(C2:C6;A2:A6;E2&".*";B2:B6;"<"&MAX(B2:B6))</item></paragraph>
<paragraph id="par_id65612244926745" role="paragraph" xml-lang="en-US">If E2 = pen, the function returns 65, because the link to the cell is substituted with its content.</paragraph>
+<embed href="text/scalc/06/calcsamplefiles.xhp#func_ifs"/>
<section id="relatedtopics">
- <paragraph id="par_id1279148769260" role="paragraph" xml-lang="en-US"><link href="text/scalc/01/04060184.xhp#average">AVERAGE</link>, <link href="text/scalc/01/04060184.xhp#averagea">AVERAGEA</link>, <embedvar href="text/scalc/01/func_averageif.xhp#averageif_head"/>, <embedvar href="text/scalc/01/func_sumifs.xhp#sumifs_head"/>, <embedvar href="text/scalc/01/func_minifs.xhp#minifs_head"/>, <embedvar href="text/scalc/01/func_maxifs.xhp#maxifs_head"/>, <embedvar href="text/scalc/01/func_countifs.xhp#countifs_head"/>, <link href="text/scalc/01/04060184.xhp#max">MAX</link>, <link href="text/scalc/01/04060184.xhp#min">MIN</link></paragraph>
-<paragraph id="par_id20741445030307" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/shared/01/02100001.xhp#02100001"/></paragraph>
+ <paragraph id="par_id11921178730928" role="paragraph" xml-lang="en-US" localize="false">
+ <embedvar href="text/scalc/01/04060184.xhp#average_head"/>,
+ <embedvar href="text/scalc/01/04060184.xhp#averagea_head"/>,
+ <embedvar href="text/scalc/01/04060184.xhp#avedev_head"/>,
+ <embedvar href="text/scalc/01/func_averageif.xhp#averageif_head"/>
+ </paragraph>
+ <paragraph id="par_id11931178730928" role="paragraph" xml-lang="en-US" localize="false">
+ <embedvar href="text/scalc/01/func_countifs.xhp#countifs_head"/>,
+ <embedvar href="text/scalc/01/func_minifs.xhp#minifs_head"/>,
+ <embedvar href="text/scalc/01/func_maxifs.xhp#maxifs_head"/>,
+ <embedvar href="text/scalc/01/func_averageifs.xhp#averageifs_head"/>,
+ <embedvar href="text/scalc/01/func_sumifs.xhp#sumifs_head"/>
+ </paragraph>
+<paragraph id="par_id20741445030307" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/shared/01/02100001.xhp#02100001"/></paragraph>
</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_countifs.xhp b/source/text/scalc/01/func_countifs.xhp
index f47b269ab..82c3c7716 100644
--- a/source/text/scalc/01/func_countifs.xhp
+++ b/source/text/scalc/01/func_countifs.xhp
@@ -54,7 +54,19 @@
<paragraph id="par_id738533068520" role="paragraph" xml-lang="en-US">If E2 = pen, the function returns 1, because the link to the cell is substituted with its content and it works as a function above.</paragraph>
<embed href="text/scalc/06/calcsamplefiles.xhp#func_ifs"/>
<section id="relatedtopics">
- <paragraph id="par_id14337286612130" role="paragraph" xml-lang="en-US"><link href="text/scalc/01/04060181.xhp#count">COUNT</link>, <link href="text/scalc/01/04060181.xhp#countif">COUNTIF</link>, <link href="text/scalc/01/04060181.xhp#counta">COUNTA</link>, <embedvar href="text/scalc/01/func_sumifs.xhp#sumifs_head"/>, <embedvar href="text/scalc/01/func_minifs.xhp#minifs_head"/>, <embedvar href="text/scalc/01/func_maxifs.xhp#maxifs_head"/>, <embedvar href="text/scalc/01/func_averageifs.xhp#averageifs_head"/>, <link href="text/scalc/01/04060184.xhp#max">MAX</link>, <link href="text/scalc/01/04060184.xhp#min">MIN</link></paragraph>
+ <paragraph id="par_id11921178730928" role="paragraph" xml-lang="en-US" localize="false">
+ <embedvar href="text/scalc/01/04060181.xhp#count_head"/>,
+ <embedvar href="text/scalc/01/04060181.xhp#countif_head"/>,
+ <embedvar href="text/scalc/01/04060181.xhp#countblank_head"/>,
+ <embedvar href="text/scalc/01/04060181.xhp#counta_head"/>
+ </paragraph>
+ <paragraph id="par_id11931178730928" role="paragraph" xml-lang="en-US" localize="false">
+ <embedvar href="text/scalc/01/func_countifs.xhp#countifs_head"/>,
+ <embedvar href="text/scalc/01/func_minifs.xhp#minifs_head"/>,
+ <embedvar href="text/scalc/01/func_maxifs.xhp#maxifs_head"/>,
+ <embedvar href="text/scalc/01/func_averageifs.xhp#averageifs_head"/>,
+ <embedvar href="text/scalc/01/func_sumifs.xhp#sumifs_head"/>
+ </paragraph>
<paragraph id="par_id235992404316585" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/shared/01/02100001.xhp#02100001"/></paragraph>
</section>
</body>
diff --git a/source/text/scalc/01/func_maxifs.xhp b/source/text/scalc/01/func_maxifs.xhp
index 43c1ac083..9483642ee 100644
--- a/source/text/scalc/01/func_maxifs.xhp
+++ b/source/text/scalc/01/func_maxifs.xhp
@@ -53,9 +53,22 @@
<paragraph id="par_id50762995519951" role="paragraph" xml-lang="en-US">If you need to change a criterion easily, you may want to specify it in a separate cell and use a reference to this cell in the condition of the MAXIFS function. For example, the above function can be rewritten as follows:</paragraph>
<paragraph id="par_id135761606425300" role="paragraph" xml-lang="en-US"><item type="input">=MAXIFS(C2:C6;A2:A6;E2&".*";B2:B6;"<"&MAX(B2:B6))</item></paragraph>
<paragraph id="par_id30574750215839" role="paragraph" xml-lang="en-US">If E2 = "pen", the function returns 65, because the reference to the cell is substituted with its content.</paragraph>
+<embed href="text/scalc/06/calcsamplefiles.xhp#func_ifs"/>
<section id="relatedtopics">
- <paragraph id="par_id11921178730928" role="paragraph" xml-lang="en-US"><link href="text/scalc/01/04060106.xhp#Section16">SUM</link>, <link href="text/scalc/01/04060106.xhp#Section15">SUMIF</link>, <embedvar href="text/scalc/01/func_countifs.xhp#countifs_head"/>, <embedvar href="text/scalc/01/func_averageifs.xhp#averageifs_head"/>, <embedvar href="text/scalc/01/func_minifs.xhp#minifs_head"/>, <link href="text/scalc/01/04060184.xhp#max">MAX</link>, <link href="text/scalc/01/04060184.xhp#min">MIN</link></paragraph>
- <paragraph id="par_id15970172625152" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/shared/01/02100001.xhp#02100001"/></paragraph>
+<paragraph id="par_id11921178730928" role="paragraph" xml-lang="en-US" localize="false">
+<embedvar href="text/scalc/01/04060184.xhp#max_head"/>,
+<embedvar href="text/scalc/01/04060184.xhp#maxa_head"/>,
+<embedvar href="text/scalc/01/04060184.xhp#min_head"/>,
+<embedvar href="text/scalc/01/04060184.xhp#mina_head"/>,
+</paragraph>
+<paragraph id="par_id11931178730928" role="paragraph" xml-lang="en-US" localize="false">
+<embedvar href="text/scalc/01/func_countifs.xhp#countifs_head"/>,
+<embedvar href="text/scalc/01/func_minifs.xhp#minifs_head"/>,
+<embedvar href="text/scalc/01/func_maxifs.xhp#maxifs_head"/>,
+<embedvar href="text/scalc/01/func_averageifs.xhp#averageifs_head"/>,
+<embedvar href="text/scalc/01/func_sumifs.xhp#sumifs_head"/>
+</paragraph>
+<paragraph id="par_id15970172625152" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/shared/01/02100001.xhp#02100001"/></paragraph>
</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_minifs.xhp b/source/text/scalc/01/func_minifs.xhp
index 0f5d54f55..2443e4e53 100644
--- a/source/text/scalc/01/func_minifs.xhp
+++ b/source/text/scalc/01/func_minifs.xhp
@@ -53,9 +53,23 @@
<paragraph id="par_id50762995519951" role="paragraph" xml-lang="en-US">If you need to change a criterion easily, you may want to specify it in a separate cell and use a reference to this cell in the condition of the MINIFS function. For example, the above function can be rewritten as follows:</paragraph>
<paragraph id="par_id135761606425300" role="paragraph" xml-lang="en-US"><item type="input">=MINIFS(C2:C6;A2:A6;".*"&E2;B2:B6;"<"&MAX(B2:B6))</item></paragraph>
<paragraph id="par_id30574750215839" role="paragraph" xml-lang="en-US">If E2 = "book", the function returns 180, because the reference to the cell is substituted with its content.</paragraph>
+<embed href="text/scalc/06/calcsamplefiles.xhp#func_ifs"/>
<section id="relatedtopics">
- <paragraph id="par_id11921178730928" role="paragraph" xml-lang="en-US"><link href="text/scalc/01/04060106.xhp#Section16">SUM</link>, <link href="text/scalc/01/04060106.xhp#Section15">SUMIF</link>, <embedvar href="text/scalc/01/func_countifs.xhp#countifs_head"/>, <embedvar href="text/scalc/01/func_averageifs.xhp#averageifs_head"/>, <embedvar href="text/scalc/01/func_maxifs.xhp#maxifs_head"/>, <link href="text/scalc/01/04060184.xhp#max">MAX</link>, <link href="text/scalc/01/04060184.xhp#min">MIN</link></paragraph>
- <paragraph id="par_id15970172625152" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/shared/01/02100001.xhp#02100001"/></paragraph>
+<paragraph id="par_id11921178730928" role="paragraph" xml-lang="en-US" localize="false">
+<embedvar href="text/scalc/01/04060184.xhp#max_head"/>,
+<embedvar href="text/scalc/01/04060184.xhp#maxa_head"/>,
+<embedvar href="text/scalc/01/04060184.xhp#min_head"/>,
+<embedvar href="text/scalc/01/04060184.xhp#mina_head"/>,
+</paragraph>
+<paragraph id="par_id11931178730928" role="paragraph" xml-lang="en-US" localize="false">
+<embedvar href="text/scalc/01/func_countifs.xhp#countifs_head"/>,
+<embedvar href="text/scalc/01/func_minifs.xhp#minifs_head"/>,
+<embedvar href="text/scalc/01/func_maxifs.xhp#maxifs_head"/>,
+<embedvar href="text/scalc/01/func_averageifs.xhp#averageifs_head"/>,
+<embedvar href="text/scalc/01/func_sumifs.xhp#sumifs_head"/>
+</paragraph>
+
+<paragraph id="par_id15970172625152" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/shared/01/02100001.xhp#02100001"/></paragraph>
</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_sumifs.xhp b/source/text/scalc/01/func_sumifs.xhp
index cf1c5503f..5065ea5b6 100644
--- a/source/text/scalc/01/func_sumifs.xhp
+++ b/source/text/scalc/01/func_sumifs.xhp
@@ -53,9 +53,19 @@
<paragraph id="par_id50762995519951" role="paragraph" xml-lang="en-US">If you need to change a criterion easily, you may want to specify it in a separate cell and use a reference to this cell in the condition of the SUMIFS function. For example, the above function can be rewritten as follows:</paragraph>
<paragraph id="par_id135761606425300" role="paragraph" xml-lang="en-US"><item type="input">=SUMIFS(C2:C6;A2:A6;E2&".*";B2:B6;"<"&MAX(B2:B6))</item></paragraph>
<paragraph id="par_id30574750215839" role="paragraph" xml-lang="en-US">If E2 = pen, the function returns 65, because the link to the cell is substituted with its content.</paragraph>
-
+<embed href="text/scalc/06/calcsamplefiles.xhp#func_ifs"/>
<section id="relatedtopics">
- <paragraph id="par_id11921178730928" role="paragraph" xml-lang="en-US"><link href="text/scalc/01/04060106.xhp#Section16">SUM</link>, <link href="text/scalc/01/04060106.xhp#Section15">SUMIF</link>, <embedvar href="text/scalc/01/func_countifs.xhp#countifs_head"/>, <embedvar href="text/scalc/01/func_minifs.xhp#minifs_head"/>, <embedvar href="text/scalc/01/func_maxifs.xhp#maxifs_head"/>, <embedvar href="text/scalc/01/func_averageifs.xhp#averageifs_head"/>, <link href="text/scalc/01/04060184.xhp#max">MAX</link>, <link href="text/scalc/01/04060184.xhp#min">MIN</link></paragraph>
+<paragraph id="par_id11921178730928" role="paragraph" xml-lang="en-US" localize="false">
+<embedvar href="text/scalc/01/04060106.xhp#sum_head"/>,
+<embedvar href="text/scalc/01/04060106.xhp#sumif_head"/>
+</paragraph>
+<paragraph id="par_id11931178730928" role="paragraph" xml-lang="en-US" localize="false">
+<embedvar href="text/scalc/01/func_countifs.xhp#countifs_head"/>,
+<embedvar href="text/scalc/01/func_minifs.xhp#minifs_head"/>,
+<embedvar href="text/scalc/01/func_maxifs.xhp#maxifs_head"/>,
+<embedvar href="text/scalc/01/func_averageifs.xhp#averageifs_head"/>,
+<embedvar href="text/scalc/01/func_sumifs.xhp#sumifs_head"/>
+</paragraph>
<paragraph id="par_id15970172625152" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/shared/01/02100001.xhp#02100001"/></paragraph>
</section>
</body>
More information about the Libreoffice-commits
mailing list