diff options
| -rw-r--r-- | source/text/scalc/01/04060106.xhp | 15 |
1 files changed, 10 insertions, 5 deletions
diff --git a/source/text/scalc/01/04060106.xhp b/source/text/scalc/01/04060106.xhp index 9361a9a595..013826ae9b 100644 --- a/source/text/scalc/01/04060106.xhp +++ b/source/text/scalc/01/04060106.xhp @@ -719,12 +719,17 @@ <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3159526" role="code">POWER(Base; Exponent)</paragraph> <paragraph id="par_id3159540" role="paragraph">Returns <emph>Base</emph> raised to the power of <emph>Exponent</emph>.</paragraph> -<paragraph id="par_id5081637" role="paragraph">The same result may be achieved by using the exponentiation operator ^:</paragraph> -<paragraph id="par_id9759514" role="code"><item type="literal">Base^Exponent</item></paragraph> -<note id="par_id241599040594931"><literal>=POWER(0,0)</literal> returns 1.</note> +<paragraph id="par_id5081637" role="paragraph">The same result may be achieved by using the exponentiation operator ^: <literal>Base^Exponent</literal></paragraph> +<note id="par_id241599040594931"><literal>=POWER(0,0)</literal> returns 1; <literal>=POWER(0,X)</literal> reports the #NUM! error when exponent X is negative.</note> +<warning id="par_id241599040594900"><literal>=POWER(B,X)</literal> may or may not report a #NUM! error when B is negative and X is not an integer.</warning> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> -<paragraph id="par_id3159594" role="paragraph"><item type="input">=POWER(4;3)</item> returns 64, which is 4 to the power of 3.</paragraph> -<paragraph id="par_id1614429" role="paragraph">=4^3 also returns 4 to the power of 3.</paragraph><comment>see also EXP, LOG, SQRT</comment> +<paragraph id="par_id3159594" role="paragraph"><input>=POWER(4;3)</input> returns 64, which is 4 to the power of 3.</paragraph> +<paragraph id="par_id1614429" role="paragraph"><input>=4^3</input> also returns 4 to the power of 3.</paragraph> +<paragraph id="par_id1614444" role="paragraph"><input>=POWER(2;-3)</input> returns 0.125.</paragraph> +<paragraph id="par_id1614455" role="paragraph"><input>=POWER(-2;1/3)</input> returns -1.25992104989487.</paragraph> +<paragraph id="par_id1614466" role="paragraph"><input>=POWER(-2;2/3)</input> returns the #NUM! error.</paragraph> + +<comment>see also EXP, LOG, SQRT</comment> </section> <section id="Section27"> |