Excel is a very useful office software that can help users process data production**. There are many function formulas in excel, when you need to open the root number in excel, you can use the excel root number formula, which can greatly save our calculation time and make the office faster. However, I see that there are still many friends who are asking excel how to open the root number, and the following brings you three formulas for excel to open the root number, let's take a look.
excel root number formula
There are 3 ways to open the root number in Excel, assuming the value is in cell A1, enter one of the following formulas in column B, and press enter:
=sqrt(a1)
=power(a1,1/2)
=a1^(1/2)
Note:The first type only opens the square root, and in the middle, you can open other powers, such as opening the 5th power root, then use 1 5 instead of 1 2.
The above is all the content of the excel root number formula and how to open the root number of excel brought to you today, I hope to be able to help you.
excel root number formula how to play excel open root number function formula.
How to enter the absolute value symbol in excel How to enter the formula $ in excel.
excel how to automatically sort 123 excel serial number how to pull down the method of 12345.
excel how to enter the formula to calculate how excel how to edit the function to calculate.
How to set up excel** formula calculation tutorial for automatic calculation of excel** formulas.