Difference between revisions of "Manuals/calci/NEXTPOWER"
Jump to navigation
Jump to search
| (2 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
<div style="font-size:30px">'''NEXTPOWER(Number, ToBase)'''</div><br/> | <div style="font-size:30px">'''NEXTPOWER(Number, ToBase)'''</div><br/> | ||
| − | *<math>Number</math> is the value for which a greater power value is to be | + | *<math>Number</math> is the value for which a greater power value is to be calculated |
*<math>ToBase</math> is the base value | *<math>ToBase</math> is the base value | ||
==Description== | ==Description== | ||
| − | *This function gives the next power value of | + | *This function gives the next power value of <math>ToBase</math> number, that is greater than the <math>Number</math> value. |
*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, 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''. | + | *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'''. |
*<math>Number</math> is the comparison value that can be + or -. It cannot be zero. | *<math>Number</math> is the comparison value that can be + or -. It cannot be zero. | ||
*<math>ToBase</math> is the base value, that has to be +. Calci gives error if the value is negative. | *<math>ToBase</math> is the base value, that has to be +. Calci gives error if the value is negative. | ||
| Line 14: | Line 14: | ||
==Examples== | ==Examples== | ||
| − | =NEXTPOWER(17,4) = | + | =NEXTPOWER(17,4) = 64 |
| − | =NEXTPOWER(26, | + | =NEXTPOWER(26,11) = 121 |
| − | =NEXTPOWER(5.2,3) = | + | =NEXTPOWER(5.2,3) = 9 |
| − | =NEXTPOWER(6,0.2) = | + | =NEXTPOWER(6,0.2) = NaN |
| − | =NEXTPOWER(2, | + | =NEXTPOWER(2/7,1/2) = 0.25 |
=NEXTPOWER(50,0) = 1 | =NEXTPOWER(50,0) = 1 | ||
| − | =NEXTPOWER(7,-2) = | + | =NEXTPOWER(7,-2) = #ERROR |
==Related Videos== | ==Related Videos== | ||
| − | {{#ev:youtube| | + | {{#ev:youtube|v=OXofcKM3XRY|280|center|POWER}} |
==See Also== | ==See Also== | ||
| + | *[[Manuals/calci/POWER | POWER ]] | ||
*[[Manuals/calci/EXP | EXP ]] | *[[Manuals/calci/EXP | EXP ]] | ||
| − | + | ||
| − | |||
==References== | ==References== | ||
Latest revision as of 08:55, 9 June 2020
NEXTPOWER(Number, ToBase)
- is the value for which a greater power value is to be calculated
- is the base value
is the value for which a greater power value is to be calculated
is the base valueDescription
- This function gives the next power value of number, that is greater than the value.
- The power of a number indicating how many times we have to multiply the number.
- 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 value '4'. Hence the result is 9.
- is the comparison value that can be + or -. It cannot be zero.
- is the base value, that has to be +. Calci gives error if the value is negative.
- Power is also called Exponents or Indices.
- 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.
Examples
=NEXTPOWER(17,4) = 64 =NEXTPOWER(26,11) = 121 =NEXTPOWER(5.2,3) = 9 =NEXTPOWER(6,0.2) = NaN =NEXTPOWER(2/7,1/2) = 0.25 =NEXTPOWER(50,0) = 1 =NEXTPOWER(7,-2) = #ERROR
Related Videos
See Also
References