Manuals/calci/NEXTPOWER

From ZCubes Wiki
Revision as of 08:55, 9 June 2020 by Devika (talk | contribs) (→‎Examples)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
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

POWER

See Also


References