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
- Begin by typing in =POWER(
- Select or type in the range reference that contains the base number that is to be multiplied (i.e. B3)
- Select or type in the range reference that contains the multiplier (i.e. C3)
- 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