Functions : 9 Round Functions

This chapter illustrates three functions to round numbers in Excel. The ROUND, ROUNDUP and ROUNDDOWNfunction.
Before your start: if you round a number, you lose precision. If you don't want this, show fewer decimal placeswithout changing the number itself.

Round

1. Round a number to two decimal places.
Round to Two Decimal Places in Excel
Note: 1, 2, 3, and 4 get rounded down. 5, 6, 7, 8, and 9 get rounded up. In this example, 114.7211, 114.7221, 114.7231 and 114.7241 get rounded down to 114.72 and 114.7251, 114.7261, 114.7271, 114.7281 and 114.7291 get rounded up to 114.73.
2. Round a number to one decimal place.
Round to One Decimal Place
3. Round a number to the nearest integer.
Round to the Nearest Integer
4. Round a number to the nearest 10.
Round to the Nearest 10
5. Round a number to the nearest 100.
Round to the Nearest 100

RoundUp

The ROUNDUP function always rounds a number up (away from zero). For example, round a number up to one decimal place.
Round Up to One Decimal Place, Positive Number
Round Up to One Decimal Place, Negative Number

RoundDown

The ROUNDDOWN function always rounds a number down (toward zero). For example, round a number down to the nearest integer.

Round Down to the Nearest Integer, Positive Number
Round Down to the Nearest Integer, Negative Number

No comments:

Post a Comment