Use the round function to make rounding more accurate

Source: Internet
Author: User
Tags rounds

In the front, we introduced the use of the INT function to construct the rounding function, but sometimes we will encounter more decimal rounding, with the INT function construction will be somewhat laborious, Excel round function can help us. The role of the round function is to return a number that has been rounded off by a specified number of digits. The syntax is "ROUND (number,num_digits)", where number is a figure that needs to be rounded; Num_digits to the specified number of digits, rounded by this digit, or rounded to the specified decimal bit if the num_digits is greater than 0, or rounded to the nearest integer if the num_digits is equal to 0, if the num_digits is less than 0, rounding is rounded to the left of the decimal point.

For example,

=round (2.15, 1) rounds 2.15 to a decimal place, with a result of 2.2

=round (2.149, 1) rounds 2.149 to a decimal place result of 2.1

=round (-1.475, 2) rounding-1.475 to two decimal places results of-1.48)

=round (21.5,-1) rounding 21.5 to the left of the decimal point a result is 20

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.