What is the next number after zero

ROUND (function)

description

With the function ROUND a number is rounded to a specified number of places. For example, if cell A1 has the value 23.7825 and you want to round that value to two decimal places, you can use the following formula:

= ROUND (A1, 2)

The result of this function is 23.78.

syntax

ROUND (number; number_digits)

The ROUND function syntax has the following arguments:

  • number Required. The number to be rounded off.

  • Number_digits Required. The number of decimal places to which to round the number.

Hints

  • Is Number_digits greater than 0 (zero), the number is rounded to the specified number of decimal places.

  • Is Number_digits equals 0, the number is rounded to the nearest whole number.

  • Is Number_digits less than 0, the part of the number to the left of the decimal point is rounded.

  • If you always want to round up (from zero), use the function ROUND UP.

  • If you always want to round down (towards zero), use the function ROUND DOWN.

  • If you want to round a number to a specific multiple (e.g. to the nearest 0.5), use the function ROUND.

example

Copy and paste the sample data in the following table into cell A1 of a new Excel worksheet. To see the results of the formulas, highlight them, press F2, and then press ENTER. If necessary, you can adjust the width of the columns so that all data is displayed.

formula

description

Result

= ROUND (2.15,1)

Rounds 2.15 to one decimal place

2,2

= ROUND (2.149; 1)

Rounds 2.149 to one decimal place

2,1

= ROUND (-1.475,2)

Rounds -1.475 to two decimal places

-1,48

= ROUND (21.5, -1)

Rounds 21.5 to one decimal place to the left of the decimal point

20

= ROUND (626.3; -3)

Rounds 626.3 to the nearest multiple of 1000

1000

= ROUND (1.98; -1)

Rounds 1.98 to the nearest multiple of 10

0

= ROUND (-50.55, -2)

Rounds -50.55 to the nearest multiple of 100

-100