From 0f00c50e4c719fede7d5602e3d29d395bfaf26d6 Mon Sep 17 00:00:00 2001 From: Stanislav Horacek Date: Tue, 29 Dec 2015 22:05:46 +0100 Subject: AVERAGEIF: fix example Change-Id: I31fa85189ab4bb24d91e0a0366b08868121b8d47 Reviewed-on: https://gerrit.libreoffice.org/21006 Reviewed-by: Adolfo Jayme Barrientos Tested-by: Adolfo Jayme Barrientos --- source/text/scalc/01/func_averageif.xhp | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'source/text') diff --git a/source/text/scalc/01/func_averageif.xhp b/source/text/scalc/01/func_averageif.xhp index 5bbf17616a..277abb625d 100644 --- a/source/text/scalc/01/func_averageif.xhp +++ b/source/text/scalc/01/func_averageif.xhp @@ -62,8 +62,8 @@ If the whole range is empty, contains only text or all values of the range do no 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 AVERAGEIF function. =AVERAGEIF(A2:A6;".*"&E2&".*";B2:B6) The function searches what cells from the range A2:A6 contain a combination of symbols specified in E2 starting and ending with any quantity of other symbols, and calculates the average of corresponding values from the B2:B6 range. If E2 = book, the function returns 18.5. -=AVERAGEIF(A2:A6;"<"&E2;B2:B6) -The function searches what cells from the range A2:A6 are less than the value specified in E2, and calculates the average of corresponding values from the B2:B6 range. If E2 = 35, the function returns 145. +=AVERAGEIF(B2:B6;"<"&E2;C2:C6) +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.
AVERAGE, AVERAGEA, , MAX, MIN, LARGE, SMALL -- cgit