diff options
| author | Stanislav Horacek <stanislav.horacek@gmail.com> | 2015-02-28 15:27:34 +0100 |
|---|---|---|
| committer | Adolfo Jayme Barrientos <fitojb@ubuntu.com> | 2015-02-28 16:59:01 +0000 |
| commit | 2f84d05cecc0265902c5df3afc22adf8a046a3c1 (patch) | |
| tree | a3d6d1249da8aba4626a08f118967fcd3b0283af /source/text/scalc/01/04060104.xhp | |
| parent | 649cf89040199e5dee52a195768a0e6688b6d420 (diff) | |
Change-Id: I85624c210d87e9cccaf7ddd3db53b52f37f4fb34
Reviewed-on: https://gerrit.libreoffice.org/14680
Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
Tested-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
Diffstat (limited to 'source/text/scalc/01/04060104.xhp')
| -rw-r--r-- | source/text/scalc/01/04060104.xhp | 44 |
1 files changed, 44 insertions, 0 deletions
diff --git a/source/text/scalc/01/04060104.xhp b/source/text/scalc/01/04060104.xhp index 5ea5463000..0859780a3d 100644 --- a/source/text/scalc/01/04060104.xhp +++ b/source/text/scalc/01/04060104.xhp @@ -371,6 +371,29 @@ <paragraph role="paragraph" id="par_id3159182" xml-lang="en-US" l10n="CHG" oldref="67"> <item type="input">=ISFORMULA(C4)</item> returns FALSE if the cell C4 contains the number <item type="input">5</item>.</paragraph> </section> +<section id="iseven"> +<bookmark xml-lang="en-US" branch="index" id="bm_id3156048"><bookmark_value>ISEVEN function</bookmark_value> +<bookmark_value>even integers</bookmark_value> +</bookmark> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ISTGERADE" id="bm_id3149430" localize="false"/> +<paragraph xml-lang="en-US" id="hd_id3156048" role="heading" level="2">ISEVEN</paragraph> +<paragraph xml-lang="en-US" id="par_id3149169" role="paragraph"><ahelp hid="HID_FUNC_ISTGERADE">Returns TRUE if the value is an even integer, or FALSE if the value is odd.</ahelp></paragraph> +<paragraph xml-lang="en-US" id="hd_id3146928" role="heading" level="3">Syntax</paragraph> +<paragraph xml-lang="en-US" id="par_id3151203" role="code">ISEVEN(Value)</paragraph> +<paragraph xml-lang="en-US" id="par_id3150491" role="paragraph"><emph>Value</emph> is the value to be checked.</paragraph> +<paragraph xml-lang="en-US" id="par_id3445844" role="paragraph">If Value is not an integer any digits after the decimal point are ignored. The sign of Value is also ignored.</paragraph> +<paragraph xml-lang="en-US" id="hd_id3154136" role="heading" level="3">Example</paragraph> +<paragraph xml-lang="en-US" id="par_id3163813" role="paragraph"> +<item type="input">=ISEVEN(48)</item> returns TRUE</paragraph> +<paragraph xml-lang="en-US" id="par_id8378856" role="paragraph"> +<item type="input">=ISEVEN(33)</item> returns FALSE</paragraph> +<paragraph xml-lang="en-US" id="par_id7154759" role="paragraph"> +<item type="input">=ISEVEN(0)</item> returns TRUE</paragraph> +<paragraph xml-lang="en-US" id="par_id1912289" role="paragraph"> +<item type="input">=ISEVEN(-2.1)</item> returns TRUE</paragraph> +<paragraph xml-lang="en-US" id="par_id5627307" role="paragraph"> +<item type="input">=ISEVEN(3.999)</item> returns FALSE</paragraph><comment>see also ISODD </comment> +</section> <section id="iseven_add"> <bookmark xml-lang="en-US" branch="index" id="bm_id3149760"><bookmark_value>ISEVEN_ADD function</bookmark_value> </bookmark> @@ -475,6 +498,27 @@ <paragraph role="paragraph" id="par_id3148416" xml-lang="en-US" l10n="CHG" oldref="108"> <item type="input">=ISTEXT(C3)</item> returns FALSE if cell C3 contains the number <item type="input">3</item>.</paragraph> </section> +<section id="isodd"> +<bookmark xml-lang="en-US" branch="index" id="bm_id3156034"><bookmark_value>ISODD function</bookmark_value> +<bookmark_value>odd integers</bookmark_value> +</bookmark> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ISTUNGERADE" id="bm_id3149298" localize="false"/> +<paragraph xml-lang="en-US" id="hd_id3156034" role="heading" level="2">ISODD</paragraph> +<paragraph xml-lang="en-US" id="par_id3155910" role="paragraph"><ahelp hid="HID_FUNC_ISTUNGERADE">Returns TRUE if the value is odd, or FALSE if the number is even.</ahelp></paragraph> +<paragraph xml-lang="en-US" id="hd_id3151006" role="heading" level="3">Syntax</paragraph> +<paragraph xml-lang="en-US" id="par_id3151375" role="code">ISODD(value)</paragraph> +<paragraph xml-lang="en-US" id="par_id3155139" role="paragraph"><emph>Value</emph> is the value to be checked.</paragraph> +<paragraph xml-lang="en-US" id="par_id9027680" role="paragraph">If Value is not an integer any digits after the decimal point are ignored. The sign of Value is also ignored.</paragraph> +<paragraph xml-lang="en-US" id="hd_id3163723" role="heading" level="3">Example</paragraph> +<paragraph xml-lang="en-US" id="par_id3155345" role="paragraph"> +<item type="input">=ISODD(33)</item> returns TRUE</paragraph> +<paragraph xml-lang="en-US" id="par_id9392986" role="paragraph"> +<item type="input">=ISODD(48)</item> returns FALSE</paragraph> +<paragraph xml-lang="en-US" id="par_id5971251" role="paragraph"> +<item type="input">=ISODD(3.999)</item> returns TRUE</paragraph> +<paragraph xml-lang="en-US" id="par_id4136478" role="paragraph"> +<item type="input">=ISODD(-3.1)</item> returns TRUE</paragraph><comment>see also ISEVEN</comment> +</section> <section id="isodd_add"> <bookmark xml-lang="en-US" branch="index" id="bm_id3153939"><bookmark_value>ISODD_ADD function</bookmark_value> </bookmark> |