Home  >  Article  >  Software Tutorial  >  How to set up automatic calculation in WPS2019 How to set up automatic calculation in WPS2019

How to set up automatic calculation in WPS2019 How to set up automatic calculation in WPS2019

WBOY
WBOYOriginal
2024-08-20 10:35:31604browse

Recently, many friends have asked me how to set up automatic calculation in WPS2019. Next, let us learn how to set up automatic calculation in WPS2019. I hope it can help everyone. How to set up automatic calculation in WPS2019? The first step of how to set up automatic calculation in WPS2019: First select the table to display the calculation results, as shown in the figure.

WPS2019怎么设置自动计算 WPS2019怎么设置自动计算的方法

Step 2: Then right-click the table and click [Format Cells], as shown in the picture.

WPS2019怎么设置自动计算 WPS2019怎么设置自动计算的方法

Step 3: Then select [General] or [Numeric] under [Number], as shown in the picture.

WPS2019怎么设置自动计算 WPS2019怎么设置自动计算的方法

Step 4: Enter [=EVALUATE()] in the table where the results are to be displayed. The content in the brackets is the cell where the calculation is located. For example, the editor’s calculation is in A4, which is = EVALUATE(A4), as shown in the figure.

WPS2019怎么设置自动计算 WPS2019怎么设置自动计算的方法

Step 5: Finally, click the enter key, and the result of the formula will be automatically calculated, as shown in the picture.

WPS2019怎么设置自动计算 WPS2019怎么设置自动计算的方法

The above is the detailed content of How to set up automatic calculation in WPS2019 How to set up automatic calculation in WPS2019. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn