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.hal...@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.hal...@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>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
