You can always use caret symbol (^) to find a certain power of a number. However, doing this with a formula can be easier to read and identify in nested formula sets.

Syntax

=POWER(base number, how many times that base number will be multiplied by itself)

Steps

  1. Begin by typing in =POWER(
  2. Select or type in the range reference that contains the base number that is to be multiplied (i.e. B3)
  3. Select or type in the range reference that contains the multiplier (i.e. C3)
  4. Close the formula with ) and press Enter to complete it

How

The POWER function gets 2 arguments. First is the base number that is to be multiplied (i.e. B3), and the second is the power level (i.e. C3). For example, =POWER(2,6) means 2*2*2*2*2*2 which is equal to 64.

=POWER(B3,C3)

The same formula can be written using the operation below:

=B3^C3