How to use the WPS table automatic calculation function

method of using WPS table to calculate function automatically

Create a new form, this one will all ha ~ and then open.

Where you want to enter the calculation formula, such as: 1+2*3+4*5

First choose the form format "General": Left click on the one you need results: Right---Set cell formatting---general---Click OK

Copy command formula "=evaluate ()" .... Move the mouse position to the parentheses of the formula, click the calculated table you want to calculate, or enter the formula form code you want to calculate directly in parentheses, such as F5, which means line 5th of column F.

Then the carriage return is determined, the calculation results are out ... If your table format is text, the following situation will appear.