Solution of error in Excel summation

Source: Internet
Author: User

Excel is to do the financial statements can not help, but occasionally to do accurate data files, suddenly found that Excel error then how to solve? In the financial wage statement, involving the "payroll tax" calculation, the author in accordance with the "payroll tax" calculation method, work out the calculation of Excel formula, The results of the operation are automatically filled in the tax cell for each employee, based on the relevant calculation of each employee's income item. However, in the "tax column" longitudinal summary summation, but found that the result of automatic summation than the actual sum of the results of more than a few cents.

Excel table

After analysis, we found that when we use Excel to sum up the calculation (especially the data containing decimal places), you will typically set the two-bit decimal number in the cell's format properties, and Excel's automatic computing function will often be accurate to more than two digits after the decimal point, but is not visible in the table because of the user's setting. In this way, Excel adds the exact bit to the sum, rather than adding the two-bit decimal number shown, which results in rounding errors.

Solution: In the payroll of each employee "tax column" formula, in advance to add "rounding" function, namely: Payroll tax =round (tax calculation formula, 2), the results of the calculation to retain two decimal places. So that excel in the data calculation, according to "display bit" to get the calculation results, to avoid the "exact bit" added by the implicit error, so that the problem solved.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.