Excel Round Function

Round function is a built in excel function categorized as Math/ Trig Function. It can be used as a worksheet function in excel and VBA.

Purpose

To return a number rounded to the specified number of places

Syntax

=ROUND(Number, Num_Digits)

Arguments

• Number.REQUIRED. The number that you want to round
• Num_Digits. REQUIRED. The number of digits to which you want to round the number argument

If Num_Digits is:

• Zero (0). The number is rounded to the nearest integer.
• Greater Than Zero (>0). The number is rounded to the specified number of places in the right of decimal point.
• Less than zero (<0). The number is rounded to the specified number of places in left of the decimal point.

Return Type

Number

Remarks

• To always round up (away from zero), use the ROUNDUP function
• To always round down (toward zero), use the ROUNDDOWN function
• If a number is already rounded to the given number of places, no rounding occurs