How to enter the root formula in excel

Method: First open the excel table that needs to be operated, select the specified cell; then click the "Format" - "Math and Trigonometric Functions" option at the top of the page, select "power"; then enter "number" Enter the specified base number in the box, enter any fraction in the "power" input box; finally click the OK button.

The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

The specific operation method of entering the root formula in the EXCEL table is as follows:

Open excel. Click "Function" in the menu bar and select "Mathematics and Trigonometric Functions" to pop up a "Function Parameters" dialog box.

At the same time, the returned function is displayed on the cell page: POWER()

"Function parameters" The dialog box has two items, one is Number: it is the base. Can be any real number.

One item is Power: it is a power value. If you want to calculate 17 to the 5th power, enter 17 in the base of Number, enter 5 in the Power value, and the cell will display POWER(17,5 ), click OK to calculate the result.

If you want to open the 4th power of 36, enter 36 in the base of Number, enter 1/4 in the power value, and the cell will display POWER( 36,1/4), this is the result that can be calculated by clicking OK.

You can also enter the formula directly in the cell without the first step: POWER(Number,Power), Number is the base and can be any real number. Power: It is a power value. If you want to calculate 17 raised to the 5th power, directly enter =POWER(17,5) in the cell and press Enter.

If you want to add the 4th power to 36, directly enter =POWER(36,1/4) in the cell and press Enter.

Be sure to pay attention to the input of "equal sign=", calculation cannot be done without the equal sign

excel tutorial

The above is the detailed content of How to enter the root formula in excel. For more information, please follow other related articles on the PHP Chinese website!