Step 1: Click on the cell where you wish to calculate.
Let’s see how we can write this up in excel: Let’s assume we have the same example, 2 3, and we will write it as 2^3. The other easy and most useful way to calculate exponents in excel is by using the shorthand notation “^” as shown below: The above two examples clearly show the difference between (2 3) 4 and (2) 32Īlso, you can use multiple POWER functions as per the need. Once you press Enter, you will get the desired output or result. In case we have something like (2) 32, then we need to use the below formula, and it will give us different results:
Step 2: Enter the formula below in the selected cell.Īnd then press Enter, you will get the desired output or result. Step 1: Click on the cell where you want to insert the formula. We will see this in the below example using the above mathematical equation. We should note that the order of brackets is very important, and they can alter our results.
HOW TO TYPE AN EXPONENT IN WORD HOW TO
To understand the concept in-depth, let’s solve a mathematical equation, and then we will learn how to do the same thing in excel. In this new example, we are going to learn the use of power function inside another power function. The above example was quite easy to understand the functionality of the POWER function. Step 2: Enter the formula below in the destination cell.Īnd as you press Enter, you will get the desired output or result. Step 1: Click on the cell where you wish to write the formula.
0 kommentar(er)
