Introduction to the number function ROUND rounded up in Excel

(1) Functions
Rounds the value by the specified number of digits.
(2) Format
ROUND (number or number cell, the specified number of digits)
(3) Example
Column A and column B
12.351
325.525
......
Input formula in B1
① Keep two decimal places-rounded from the sub-digit to the percentile.
= ROUND (A1, 2) = 12.35
Copy the formula down to B2
= ROUND (A2, 2) = 325.53
② Rounded to an integer -- rounded to a reserved integer from the very bit.
Input formula in B1
= ROUND (A1, 0) = 12
Copy the formula down to B2
= ROUND (A2, 0) = 326
③ Rounding to ten -- from a single digit to ten digits is retained to ten digits.
Input formula in B1
= ROUND (A1,-1) = 10
Copy the formula down to B2
= ROUND (A2,-1) = 330
Note:
The 1st parameter of the ROUND function can be a specific value or a value cell reference.
The 2nd parameter of the ROUND function-specifies the number of reserved digits. The number of reserved decimal places is expressed by a positive integer, that is, 1, 2, 4 ...... (Corresponding to the very bit, percentile, kilobytes, and ten thousandths ......); The reserved integer is represented by a non-positive integer, that is, 0,-1,-2,-3 ,...... (Corresponding to a single digit, ten digits, hundreds of digits ......).

Related content:

• How can I get the excel rounded up? Is the whole function rounded up?
• How to force line breaks in excel tables?
• How to Use the excel rounding function?
• How can I get an excel worksheet?