INTEGRATION: CWS hcshared17_DEV300 (1.11.8); FILE MERGED

2008/02/22 09:23:20 ufi 1.11.8.1: vor resync

1 files changed, 6 insertions, 2 deletions

diff --git a/helpcontent2/source/text/scalc/01/04060184.xhp b/helpcontent2/source/text/scalc/01/04060184.xhp
index a662086a12..35fd923722 100755
--- a/helpcontent2/source/text/scalc/01/04060184.xhp
+++ b/helpcontent2/source/text/scalc/01/04060184.xhp
@@ -7,9 +7,9 @@
  *
  *  $RCSfile: 04060184.xhp,v $fileonly,v $
  *
- *  $Revision: 1.11 $
+ *  $Revision: 1.12 $
  *
- *  last change: $Author: vg $ $Date: 2008-01-24 13:53:05 $
+ *  last change: $Author: kz $ $Date: 2008-03-07 12:08:10 $
  *
  *  The Contents of this file are made available subject to
  *  the terms of GNU Lesser General Public License Version 2.1.
@@ -53,6 +53,7 @@
 </bookmark>
 <bookmark xml-lang="en-US" branch="hid/HID_FUNC_MAX" id="bm_id3146972" localize="false"/><paragraph role="heading" id="hd_id3154511" xml-lang="en-US" level="2" l10n="U" oldref="2">MAX</paragraph>
 <paragraph role="paragraph" id="par_id3153709" xml-lang="en-US" l10n="U" oldref="3"><ahelp hid="HID_FUNC_MAX">Returns the maximum value in a list of arguments.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id9282509" xml-lang="en-US" l10n="NEW">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 role="heading" id="hd_id3154256" xml-lang="en-US" level="3" l10n="U" oldref="4">Syntax</paragraph>
 <paragraph role="code" id="par_id3147340" xml-lang="en-US" l10n="U" oldref="5">MAX(Number1; Number2; ...Number30)</paragraph>
 <paragraph role="paragraph" id="par_id3149568" xml-lang="en-US" l10n="CHG" oldref="6">
@@ -68,6 +69,7 @@
 </bookmark>
 <bookmark xml-lang="en-US" branch="hid/HID_FUNC_MAXA" id="bm_id3150304" localize="false"/><paragraph role="heading" id="hd_id3166426" xml-lang="en-US" level="2" l10n="U" oldref="139">MAXA</paragraph>
 <paragraph role="paragraph" id="par_id3150363" xml-lang="en-US" l10n="U" oldref="140"><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 role="paragraph" id="par_id7689443" xml-lang="en-US" l10n="NEW">The functions MINA() and MAXA() return 0 if no value (numeric or text) and no error was encountered.</paragraph>
 <paragraph role="heading" id="hd_id3150516" xml-lang="en-US" level="3" l10n="U" oldref="141">Syntax</paragraph>
 <paragraph role="code" id="par_id3166431" xml-lang="en-US" l10n="U" oldref="142">MAXA(Value1; Value2; ... Value30)</paragraph>
 <paragraph role="paragraph" id="par_id3150202" xml-lang="en-US" l10n="CHG" oldref="143">
@@ -96,6 +98,7 @@
 </bookmark>
 <bookmark xml-lang="en-US" branch="hid/HID_FUNC_MIN" id="bm_id3159226" localize="false"/><paragraph role="heading" id="hd_id3154541" xml-lang="en-US" level="2" l10n="U" oldref="19">MIN</paragraph>
 <paragraph role="paragraph" id="par_id3143222" xml-lang="en-US" l10n="U" oldref="20"><ahelp hid="HID_FUNC_MIN">Returns the minimum value in a list of arguments.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id2301400" xml-lang="en-US" l10n="NEW">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 role="heading" id="hd_id3154651" xml-lang="en-US" level="3" l10n="U" oldref="21">Syntax</paragraph>
 <paragraph role="code" id="par_id3146964" xml-lang="en-US" l10n="U" oldref="22">MIN(Number1; Number2; ...Number30)</paragraph>
 <paragraph role="paragraph" id="par_id3153486" xml-lang="en-US" l10n="CHG" oldref="23">
@@ -109,6 +112,7 @@
 </bookmark>
 <bookmark xml-lang="en-US" branch="hid/HID_FUNC_MINA" id="bm_id3155752" localize="false"/><paragraph role="heading" id="hd_id3147504" xml-lang="en-US" level="2" l10n="U" oldref="148">MINA</paragraph>
 <paragraph role="paragraph" id="par_id3147249" xml-lang="en-US" l10n="U" oldref="149"><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 role="paragraph" id="par_id4294564" xml-lang="en-US" l10n="NEW">The functions MINA() and MAXA() return 0 if no value (numeric or text) and no error was encountered.</paragraph>
 <paragraph role="heading" id="hd_id3150435" xml-lang="en-US" level="3" l10n="U" oldref="150">Syntax</paragraph>
 <paragraph role="code" id="par_id3153336" xml-lang="en-US" l10n="U" oldref="151">MINA(Value1; Value2; ... Value30)</paragraph>
 <paragraph role="paragraph" id="par_id3146098" xml-lang="en-US" l10n="CHG" oldref="152">