|
|
| Line 1: |
Line 1: |
| − | <div id=" 16SpaceContent" align="left"><div class="ZEditBox" align="justify"> | + | <div style="font-size:30px">'''POWER(n,p)'''</div><br/> |
| | + | *<math>n</math> is the base value |
| | + | *<math>p </math> is the power value |
| | | | |
| − | Syntax
| |
| | | | |
| − | </div></div> | + | ==Description== |
| − | ----
| + | *This function gives the value of a number raised to a power. |
| − | <div id="4SpaceContent" align="left"><div class="ZEditBox" align="justify">
| + | *The power of a number indicating how many times we have to multiply the number. |
| | + | *For e.g POWER(4,3)=4*4*4=63. |
| | + | *In <math> POWER(n,p) ,n is the base value.It can be any '+' or '-'. |
| | + | *<math> p</math> is the power (exponent) value to which the n is raised. |
| | + | *Power is also called Exponents or Indices. |
| | + | *Anything raised to the power 0 is equal to 1.i.e.,POWER(7,0)=1. |
| | + | *We can use the "^" operator instead of POWER function. |
| | | | |
| − | Remarks
| |
| | | | |
| − | </div></div>
| + | ==Examples== |
| − | ----
| + | #POWER(17,4)=83521 |
| − | <div id="2SpaceContent" align="left"><div class="ZEditBox" align="justify">
| + | #POWER(26,1)=26 |
| | + | #POWER(5.2,3)=140.608 |
| | + | #POWER(6,0.2)=1.430969081 |
| | + | #POWER(2,3/4)=1.681792831 |
| | + | #POWER(50,0)=1 |
| | + | #POWER(7,-2)=0.020408163 |
| | | | |
| − | Examples
| + | ==See Also== |
| | + | *[[Manuals/calci/EXP | EXP ]] |
| | + | *[[Manuals/calci/SIN | SIN ]] |
| | + | *[[Manuals/calci/COS | COS ]] |
| | | | |
| − | </div></div>
| |
| − | ----
| |
| − | <div id="8SpaceContent" align="left"><div class="ZEditBox" align="justify">'''<font face="Times New Roman">''''''''''''<font size="6"> </font>''' '''''''''</font>'''</div></div>
| |
| − | ----
| |
| − | <div id="11SpaceContent" align="left"><div class="ZEditBox mceEditable" align="justify">
| |
| | | | |
| − | <font size="5">Description</font>
| + | ==References== |
| − | | |
| − | </div></div>
| |
| − | ----
| |
| − | <div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">'''<font face="Times New Roman"> <font size="6">POWER</font> </font>'''</div></div>
| |
| − | ----
| |
| − | <div id="3SpaceContent" class="zcontent" align="left"><br /><div id="7Space" class="gamizbox" title="7Space"><div id="7SpaceHeader" class="zheaderstyle" title="Double-click to start and stop editing the header."><center></center></div><div id="7SpaceRollup" title="Double-click to rolldown" align="left"><span><span id="7SpaceRollupContent" align="center"></span></span></div><div id="7SpaceCover"><div id="7SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"><font size="3"><font face="Times New Roman">
| |
| − | | |
| − | POWER (N, P)
| |
| − | | |
| − | Where''' N''' is the base number and '''P '''is the exponent to which '''N''' is raised.
| |
| − | | |
| − | </font></font></div></div>
| |
| − | ----
| |
| − | <div id="13SpaceContent" class="zcontent" align="left"><br /><br /><div id="1Space" class="gamizbox" title="1Space"><div id="1SpaceHeader" class="zheaderstyle" title="Double-click to start and stop editing the header."><center></center></div><div id="1SpaceRollup" title="Double-click to rolldown" align="left"><span><span id="1SpaceRollupContent" align="center"></span></span></div><div id="1SpaceCover"><div id="1SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"><font size="3"> </font>
| |
| − | | |
| − | <font face="Times New Roman">This function (“^”) will use instead of POWER.</font>
| |
| − | | |
| − | <font face="Times New Roman"> </font>
| |
| − | | |
| − | <font face="Times New Roman">. </font>
| |
| − | | |
| − | </div></div>
| |
| − | ----
| |
| − | <div id="14SpaceContent" class="zcontent" align="left"><br /><br /><br /><div id="5Space" class="gamizbox" title="5Space"><div id="5SpaceHeader" class="zheaderstyle" title="Double-click to start and stop editing the header."><center></center></div><div id="5SpaceRollup" title="Double-click to rolldown" align="left"><span><span id="5SpaceRollupContent" align="center"></span></span></div><div id="5SpaceCover"><div id="5SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">
| |
| − | | |
| − | POWER function raises a particular number to the particular power.
| |
| − | | |
| − | </div></div>
| |
| − | ----
| |
| − | <div id="12SpaceContent" class="zcontent" align="left"><br /><br /><br /><div id="9Space" class="gamizbox" title="9Space"><div id="9SpaceHeader" class="zheaderstyle" title="Double-click to start and stop editing the header."><center></center></div><div id="9SpaceRollup" title="Double-click to rolldown" align="left"><span><span id="9SpaceRollupContent" align="center"></span></span></div><div id="9SpaceCover"><div id="9SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"><font size="3"><font face="Times New Roman">
| |
| − | | |
| − | Lets see an example
| |
| − | | |
| − | POWER (N, P)
| |
| − | | |
| − | POWER (C1R1, C2R1)''''''
| |
| − | | |
| − | That is POWER (8, 3) is 512
| |
| − | | |
| − | </font></font></div></div>
| |
| − | ----
| |
| − | <div id="6SpaceContent" class="zcontent" align="left">
| |
| − | | |
| − | {| id="TABLE3" class="SpreadSheet blue"
| |
| − | |- class="even"
| |
| − | | class=" " |
| |
| − | <div id="6Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
| |
| − | | Column1
| |
| − | | class=" " | Column2
| |
| − | | class=" " | Column3
| |
| − | | class=" " | Column4
| |
| − | |- class="odd"
| |
| − | | class=" " | Row1
| |
| − | | class="sshl_f" | 8
| |
| − | | class="sshl_f" | 3
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | |- class="even"
| |
| − | | class=" " | Row2
| |
| − | | class="sshl_f" | 512
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | |- class="odd"
| |
| − | | Row3
| |
| − | | class="sshl_f SelectTD SelectTD" |
| |
| − | <div id="6Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="6Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | |- class="even"
| |
| − | | Row4
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | |- class="odd"
| |
| − | | class=" " | Row5
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | |- class="even"
| |
| − | | Row6
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | |}
| |
| − | | |
| − | <div align="left">[[Image:calci1.gif]]</div></div>
| |
| − | ----
| |
| − | </div></div></div></div></div></div></div></div></div></div></div></div>
| |
is the base value
is the power value
is the power (exponent) value to which the n is raised.