How to avoid the error of Excel

Source: Internet
Author: User
Tags arithmetic

Common skills in Excel when you perform complex arithmetic operations in Excel, the calculated results are sometimes slightly different from the results of the electronic calculator, especially in the case of multiple division operations leaving more than a few, the arithmetic "error" is very easy to produce, the reason is that excel in addition to the endless circumstances, Values are not rounded automatically. This is certainly not permissible in demanding financial statements, and there are two ways to avoid this "error":

1. Use the Round function to round the median value the format of the Round function in Excel is: Round (numeric, reserved decimal places), which acts as a rounding of the specified number and retains the specified number of decimal places. For example, round (8.8888,2) means rounding the thousand points of 8.8888, The result is 8.89, of course, for the convenience of work, the value of this function can also be a cell address or other arithmetic formula, each intermediate value after this processing the final result of the calculation and calculator calculated the same.

2. Correctly set the Excel option to avoid the "error" the above function method is convenient, but when you encounter a large Excel table, if each cell to set this function, the workload is too great, then we can enter Excel [Tools]→[menu]→[option]→[recalculation], in the " Workbook options Check "to show accuracy", the Excel "error" can also be effectively avoided, and by default this small option is not checked.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

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: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.