How to do the power of in excel

The power of a number can be very useful when dealing with mathematical problems, e.g. calculating areas, functions, etc. To do the power of in Excel there are two main options:

  • Option 1. To use the “POWER” function;
  • Option 2. To use the “^” operator.

Option 1 – To use the “POWER” function

Excel offers the “POWER” function to calculate the power of. To use this function proceed as follows.

Step 1 – Select in which cell you’ll write the function 

  • Select the cell by clicking on it or with the keyboard arrows.

Step 2 – Write the function

  • Inside the selected cell write “=” to let the tool understand you want to insert a function;
  • Start writing “POWER” and the tool will suggest the POWER function;
  • Write the cell where you have the number to which you want to calculate the power of;
  • Write the power you want to use;
  • Press enter to confirm the function.

Option 2 – To use the “^” operator

An easy way to do the power of is to use the “^” operator. To do that proceed as follows.

Step 1 – Select in which cell you’ll write the function 

  • Select the cell by clicking on it or with the keyboard arrows.

Step 2 – Write the function

  • Inside the selected cell write “=” to let the tool understand you want to insert a function;
  • Select the cell you want to convert to add it to the function;
  • Write “^” after the selected cell;
  • Write the power you want to use;
  • Press enter to confirm the function.