What is the reason why the wps sum is 0?

What is the reason why the sum of wps is 0

This isbecause there is a problem with the format of the summary cell, solve it The method is as follows:

1. First prepare a set of data. What is prepared here is a list of personnel information, including three columns of information: name, age, and remarks of the personnel.

#2. After preparing the test data, add two columns of information in the remarks, namely 0.3 and 0.5. The goal is to summarize the data in these two columns.

#3. To summarize the data in these two columns, first define a summation cell, then enter the formula =sum(F6,F7), and then press Enter.

#4. After pressing Enter, it is found that the summary result is 0.

#5. This is because there is a problem with the format of the summary cell. Right-click the summary cell and click [Set Cell Format].

6. Enter [Set Cell Format], click [Numeric] mode, and then set [Number of Decimal Places] to 2 digits, you can see the correct the result of.

For more WPS/Excel tutorials, please pay attention to the Excel Basic Tutorial column!

The above is the detailed content of What is the reason why the wps sum is 0?. For more information, please follow other related articles on the PHP Chinese website!