Round a number to the nearest number

Round a number to the nearest number

To do this task, use the ROUND function.

EXAMPLE

The example may be easier to understand if you copy it to a blank worksheet.

How to copy an example

1 2 3 4

A Data 20.3 5.9 -5.9 Formula Description (Result) =ROUND(A2,0) Rounds 20.3 down, because the fractional part is less than .5 (20) =ROUND(A3,0) Rounds 5.9 up, because the fractional part is greater than .5 (6) =ROUND(A4,0) Rounds -5.9 down, because the fractional part is less than -.5 (-6)

Categories: ROUND