Difference between revisions of "Manuals/calci/NEXTPOWER"
Jump to navigation
Jump to search
Line 20: | Line 20: | ||
=NEXTPOWER(2/7,1/2) = 0.25 | =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== |
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
Description
- 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