Menu
EXCEL ROUND FUNCTION
Excel ROUND Function Introduction
This function reduces the number of digits in a number to a specified value.
Description of Excel ROUND Function
Syntax:
=ROUND (number, num_digits)
Parameter list:
- number – the number that will be rounded.
- num_digits specifies how many digits a number should be rounded to.
Step By Step Guide of ROUND Function
Example As :
- =ROUND(32.45, 1), Rounds32.45 to one decimal place as 32.5.
- =ROUND(546.7,-3), Rounds 546.7 to three decimal place to the left of the decimal point to 1000.
Key Points
- Numbers 1-4 are rounded to the nearest, whereas numbers 5-9 are rounded up.
- The ROUND function rounds integers to a given accuracy level. It has the capability to round either to the right or left of the decimal point.
- The integer is rounded to the provided number of decimal places to the right of the decimal point if num digits > 0.
- If num digits is less than zero, the number is rounded to the decimal point’s left (to the closest 10, 100, 1000, etc.).
- The number is rounded to the closest integer if num digits = 0.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
