How to enter formula with root sign in excel

Method: First open the excel table that needs to be operated, click the "Insert" - "Symbol" - "Formula" option at the top of the page; then place the mouse cursor in the inserted edit box, click on the top of the page "Formula Tool" - "Design" option, select the specified formula; finally enter the required letters and numbers in the edit box.

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

Open the EXCEL table, click "Insert" - "Symbol" - "Formula" in the menu bar

At this time, the table editing area will Automatically insert a text edit box

For non-special characters or mathematical symbols, you can directly use the keyboard to enter symbols or numbers

When there is a root sign on the right side of the equation, click "Formula Tools" - "Design" at the top of the menu bar. In the structure column below, you can see that there are many kinds of formula structures. Click on the radical type structure and automatically insert the structure into the formula

When you want to enter the power structure, select the superscript and subscript and click the icon

Use the keyboard to enter the structure in the text box Just enter numerical values, letters, or symbols.

Note that which part of the structure the cursor stops on, this part will be grayed out and the table is being edited. Which part needs to be edited, just click on this box with the mouse

Related learning recommendations:excel tutorial

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