| Line 6: |
Line 6: |
| | *This function gives the next power value of a base number, that is greater than the <math>Number</math>. | | *This function gives the next power value of a base number, that is greater than the <math>Number</math>. |
| | *The power of a number indicating how many times we have to multiply the number. | | *The power of a number indicating how many times we have to multiply the number. |
| − | *For e.g =NEXTPOWER(4,3) : For this example,. | + | *For e.g =NEXTPOWER(4,3) : For this example, 3^1, 3^2, 3^3 etc are the power values for '3'. The value 3^2 =9 is greater than <math>Number</math> value '4'. Hence the result is ''9''. |
| − | *In <math> POWER(n,p)</math>, <math>n</math> is the base value. It can be + or - .
| + | *<math>Number</math> is the comparison value that can be + or -. It cannot be zero. |
| − | *<math> p </math> is the power(exponent) value to which the <math>n</math> is raised. | + | *<math>ToBase</math> is the base value, that has to be +. Calci gives error if the value is negative. |
| | *Power is also called Exponents or Indices. | | *Power is also called Exponents or Indices. |
| − | *Anything raised to the power 0 is equal to 1. i.e. POWER(7,0) = 1. | + | *Anything raised to the power 0 is equal to 1. i.e. NEXTPOWER(7,0) = 1. |
| | *We can use the '''^''' operator instead of POWER function. | | *We can use the '''^''' operator instead of POWER function. |
| | | | |
| | ==Examples== | | ==Examples== |
| − | =POWER(17,4) = 83521 | + | =NEXTPOWER(17,4) = 83521 |
| − | =POWER(26,1) = 26 | + | =NEXTPOWER(26,1) = 26 |
| − | =POWER(5.2,3) = 140.608 | + | =NEXTPOWER(5.2,3) = 140.608 |
| − | =POWER(6,0.2) = 1.430969081 | + | =NEXTPOWER(6,0.2) = 1.430969081 |
| − | =POWER(2,3/4) = 1.681792831 | + | =NEXTPOWER(2,3/4) = 1.681792831 |
| − | =POWER(50,0) = 1 | + | =NEXTPOWER(50,0) = 1 |
| − | =POWER(7,-2) = 0.020408163 | + | =NEXTPOWER(7,-2) = 0.020408163 |
| | | | |
| | ==Related Videos== | | ==Related Videos== |