As they are formulas, when you need copy them to other cells, please paste as values.Īpply exponential calculation to a range of cells with the symbol ^Īs we can find the relevant +, -, *, / symbol on the keyboard, also we can use the symbol ^ to apply the exponential calculations. Then tap Enter key, and select cell C1, then drag the fill handle over to C10. In adjacent blank cell C1, enter this formula: =Power (A1, 3), see screenshot:Ģ. You can use this function with the following steps:ġ. Now, I have a range numbers (A1:A15), and I want to get these numbers of 3 power. The syntax for the Power function is: Power (number, power), number is a base number, power is the exponent used to raise the base number to.įor example, Power (10, 2), the number 10 is the base and the number 2 is the exponent. ![]() ![]() In Excel, the Power function returns the result of a number raised to a given power. Amazing! Using Efficient Tabs in Excel Like Chrome, Firefox and Safari! Save 50% of your time, and reduce thousands of mouse clicks for you every day!
0 Comments
Leave a Reply. |