Saltar al contenido

# How to write exponents or powers in Excel Write exponents in Excel it is very useful when we have to represent mathematical formulas. A power is a mathematical operation consisting of two numbers: the base and the exponent. The exponent determines how many times the base must be multiplied by itself. The exponent will be displayed as a supercript to the right of the base. However, a different way is used to play it in Excel. Then you will see how to correctly represent exponents in Excel.

## Step by step to represent exponents in Excel

To correctly represent exponents in Excel you can use two equally simple alternatives. By entering a symbol that will indicate that there is a power or using the POWER function.

### Entering the exponent with the cursor ^

• First you need to go to the cell where you want to place the exponent
• Write the = sign so that Excel interprets that you are entering a formula
• Then write the number that will be the base and then write the ^ symbol
• Now you can write the exponent
• Press the Enter key and Excel will interpret that after this symbol it goes to a number that represents an exponent, so it will directly put the result of the calculation.

Example:

2 ^ 6

### Entering the exponent with the POWER function

The second option is to use the POWER function, which is already configured in Excel.

To do this, just enter the SIGN =, the word POWER followed by the number that will be the base, a semicolon (;) and the number that will represent the power.

Example:

= POWER (3; 2)

Either of these two options will allow you to pick up a number to the exponent you need. Excel is a program with multiple possibilities that, in addition to mathematical operations, allows you to perform other types of tasks, such as performing a bar graph or get the absolute value of a number.

Did you know …

Japanese artist Tatsuo Horiuchi used Microsoft Excel to produce most of his paintings.

Was it useful to you? Loading …