Free All-in-One Office Suite with PDF Editor

Edit Word, Excel, and PPT for FREE.

Read, edit, and convert PDFs with the powerful PDF toolkit.

Microsoft-like interface, easy to use.

Windows • MacOS • Linux • iOS • Android

# Elementary arithmetic functions in WPS Spreadsheet

Uploaded time: October 8, 2021 Difficulty Beginner

# Elementary arithmetic functions in WPS Spreadsheet

Elementary arithmetic functions in WPS Spreadsheet

Today I will introduce you to introductory calculation of functions, namely addition, subtraction, multiplication and division. In the table, there are three ways to enter the function, respectively, input in the formula bar input in the cell and click **Insert Function**.

So how can we do elementary arithmetic in the table? We can enter the corresponding symbol for the operation in the formula bar or cells. Take this table as an example, we enter = A2 + B2 in cell C2, press the **Enter** key to get the result.

Similarly, we select cell D2, enter =A2-B2, and press the **Enter** key to get the calculation results. Then, we select cell E2, enter“=A2*B2”, and press the **Enter** key to get the calculation results. The same goes for division. Select cell F2, enter“=A2/B2”, and press the **Enter** key to get the result.

Of course, we can also use the method of inserting function to do calculation. If we want to do thesummation calculation, click the **Formulas** tab, and click the**Insert Function** button. In the popup dialog box, find the SUM function, enter the range of cells that needs to be summed, and click **OK** to quickly complete the summation.

If we want to do the subtraction calculation, select cell D2, open the **Insert Function** dialog box, find the IMSUB function, enter the range of cells that needs to be operated, and click **OK** to get the result.

If we want to do the multiplication calculation, select cell E2, open the **Insert Function** dialog box, find the PRODUCT function, enter the range of cells that needs to be operated, and click **OK** to get the result.

There is no function for performing division calculation, but the division and multiplication are inverse operations. We can convert division into multiplication. Open the **Insert Functio****n** dialog box, find the PRODUCT function, enter the range of cells that needs to be operated. Here we enter 1/B2 in the **Number2** box, and click **OK**.

Use the mouse to select cell B2:F2, double-click the fill handle to copy the formula, then we can quickly calculate the required data in batches.

Did you get it?To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.

Also Read:

- 1. A quick way to calculate sum, average, count, max, and min
- 2. Recalculate the table formulas in the Manual Recalculation mode
- 3. Use the shortcut Alt+= to quickly sum
- 4. The SUMPRODUCT function for quick calculation of total sales
- 5. Efficient statistics with statistical functions
- 6. Get started with functions and formulas

Does this video help you?