# How to insert equations in WPS Spreadsheet

Uploaded time: July 18, 2022 Difficulty Beginner

A free Office suite fully compatible with Microsoft Office

How to insert equations in WPS Spreadsheet

# How to insert equations in WPS Spreadsheet

You will be the amazing reporter with WPS Spreadsheet, which could be an alternative to Microsoft Excel.Mathematical equations contain a variety of number formats like symbols, scores, root numbers, and so on. It is difficult for us to enter these equations with the input method. However, with the Equation function in WPS Spreadsheet, inserting mathematical equations will no longer be a problem.

Click the **Insert** tab at the top of the screen, then click the **Equation** button. Here, WPS Office p data-imgw=800 data-imgh=450 data-src="//res-academy.cache.wpscdn.com/images/d31ba6b3c3af4dd1e83c197584c0973d.gif" data-test="skks"
style="max-width: 100%; width: 720px; max-height: 405px; height: calc(100vw *(450/800));
text-align:center;" >

If you can't find what you want in the drop-down menu at Equation, click **Insert New Equation”** to customize your new equation.

In the **Equation Tools** tab, we can quickly insert various basic mathematical symbols.Skillfully using **Basic Math**, we can also choose various symbol classifications, such as Operator, Arrows, and so on.

On the right side of the tab menu, we can choose many different number formats, such as **Fraction, Subscripts and Superscripts, Radical, Function,** etc.

Most mathematical equations can be entered skillfully using the two small functions we mentioned.

In addition, we can also use the **Equation Editor** to edit equations.

Click the **Insert** tab.Then click the drop-down button of **Equation**.

Finally, click **Equation Editor** to open it.

In the pop-up **Equation Editor** edit box, enter the formula and click **Close**, The formula will be inserted into the slide as a picture.

Double-click the equation to pop up the **Equation Editor** again if you want to re-edit.

What a practical feature! Did you get it?

Does this video help you?