ROUND, ROUNDDOWN, ROUNDUP functions - Functions for rounding decimal numbers in Excel
You want to round a decimal up or down depending on the problem. The following article shows in detail how to use ROUND, ROUNDDOWN, ROUNDUP functions - Decimal rounding functions in excel.
1. ROUND function
Description: The function performs rounding to a specified number of digits.
Syntax: ROUND (number, num_digits) .
Inside:
- number: The value to be rounded, is a required parameter.
- num_digits : Number of digits to round, a required parameter.
Attention:
- If num_digits value> 0 the function performs rounding to the specified number of decimal places.
- If num_digits value = 0, the function rounds to the nearest integer.
- If num_digits value
- Where you want to round to a specific multiple using MROUND .
2. ROUNDDOWN function
Description : The function performs rounding down (approaching 0 or the number before it).
Syntax : R OUNDDOWN (number, num_digits) .
Inside:
- number : The value you want to round.
- num_digits : Number of digits to round.
Attention:
- The Rounddown method is like the Round function, except it always tends to be rounded down.
- If num_digits value> 0, the function is rounded down.
- If num_digits value = 0, the function rounds down to the nearest integer.
- If num_digits value
3. ROUNDUP function
Description: The function rounds a number in the direction of getting close to the number behind it or rounding away from the number 0.
Syntax: ROUNDUP (number, NUM_DIGITS) .
Inside:
- number : The value you want to round.
- num_digits : Number of digits to round.
Attention:
- The Roundup method is like the Round function, but it is only different from the rounding function.
- If value number = 0 the function performs rounding to the nearest integer.
- If number
- Where num_digits
4. Example of use with the above 3 functions
For the same values, experiment with rounding functions with different numbers of digits:
ROUND, ROUNDDOWN, ROUNDUP functions - Functions for rounding decimal numbers in Excel Picture 1
In the cell where you need to calculate ROUNDDOWN, enter the formula: = ROUNDDOWN (B7, C7) .
ROUND, ROUNDDOWN, ROUNDUP functions - Functions for rounding decimal numbers in Excel Picture 2
Press Enter to get the results:
ROUND, ROUNDDOWN, ROUNDUP functions - Functions for rounding decimal numbers in Excel Picture 3
Similarly enter the formula with the Round function and the result is:
ROUND, ROUNDDOWN, ROUNDUP functions - Functions for rounding decimal numbers in Excel Picture 4
With ROUNDUP function :
ROUND, ROUNDDOWN, ROUNDUP functions - Functions for rounding decimal numbers in Excel Picture 5
Similarly copy the formula for the remaining cells -> the result is:
ROUND, ROUNDDOWN, ROUNDUP functions - Functions for rounding decimal numbers in Excel Picture 6
Based on the above result table you can compare the values of 3 functions with the same rounding value and the same number of digits to round. When the number of digits has a negative value, the values of 3 functions are completely different.
The above is a detailed guide on syntax and usage of rounding functions.
Good luck!
You should read it
- Compare ROUND, ROUNDUP and ROUNDDOWN rounding functions in Excel
- How to round numbers in Excel using the ROUND, ROUNDUP, ROUNDDOWN Function
- Ways to round numbers in Excel
- Instructions for rounding decimal numbers after commas in Excel
- Functions rounded up, how to round up in Excel
- ROUNDUP function in Excel - Usage and examples
- Do not round numbers in Excel, turn off rounding in Excel
- How to round whole numbers in Excel
- Round function, how to use rounded functions in Excel
- How to use math functions in C#
- How to get numbers after commas in Excel
- Round a number in Excel (ROUND function)
May be interested
SLN function - Returns the depreciation value of an asset using the straight-line method in Excel
DDB function - Calculate depreciation of assets in Excel
MINVERSE function - The function returns the inverse matrix of a given matrix in Excel
CHIDIST function - Function returns the right end probability of the distribution when squared in Excel
COUPNCD - The function returns the next coupon date in Excel
COUPPCD - The function returns the previous coupon date before the settlement date in Excel