Excel ROUND Function

Use:

Rounds a single cell or numeric formula to any degree of precision

Syntax:

ROUND( cell , digits )

Examples:

Cell C3 formula:   ROUND( B3 , 3 ) rounds to three digits after the decimal point

Cell D3 formula:   ROUND( B3 , 1 ) rounds to one digit after the decimal point
Cell E3 formula:   ROUND( B3 , 0 ) rounds to nearest whole number
Cell F3 formula:   ROUND( B3 , -2 ) rounds to nearest hundreds

Related Function:

INT