ROUND

ROUND

The ROUND function rounds a number to a specified number of digits. For example, if cell A1 contains 23.7825, and you want to round that value to two decimal places, you can use the following formula:

The result of this function is 23.78.
If 0 is used the number is rounded to the nearest whole number.
If a negative amount of rounding is used the figures to the left of the decimal point are rounded.

Syntax

ROUND(C4,D4)

 

 

 

 

 

 

 

 

 

 

 

Download file for ROUND function

 

 

Math Function

Function