Contenido del Curso
Google Spreadsheets
Google Spreadsheets
Rounding Functions
We'll explore the topic of Rounding Functions. These functions simplify numbers, which is crucial for financial reporting and data analysis. The choice of function depends on whether you need to round a number normally, always up, or always down. Let’s look at three key functions: ROUND, ROUNDUP, and ROUNDDOWN.
General Syntax:
ROUND / UP / DOWN(value, placesplaces)
- value - The number to be rounded to the specified number of places after the decimal.
- places - OPTIONAL−∗∗0∗∗bydefaultOPTIONAL - **0** by default - The number of decimal places to round to.
- places can be negative, in which case value is rounded to the specified number of places to the left of the decimal point.
Rounding
The ROUND function rounds a number to the nearest value based on standard rounding rules (5 or greater — up, less than 5 — down). It is used in scenarios where precision is important, such as financial reports or calculating averages.
| Formula | Result | Comment |
|---|---|---|
| ROUND(678.822, 0) | 679 | Rounds to 0 decimal places. 678.822 is rounded to the nearest whole number, 679, as the decimal part is greater than 0.5. |
| ROUND(678.822) | 679 | When the number of decimal places is not specified, it defaults to rounding to the nearest whole number — 679. |
| ROUND(678.822, 1) | 678.8 | Rounds to one decimal place. 678.822 becomes 678.8, as the third decimal digit is less than 5. |
| ROUND(678.822, 2) | 678.82 | Rounds to two decimal places, resulting in 678.82, as the third decimal digit (2) is less than 5. |
| ROUND(678.822, 3) | 678.822 | Rounding to three decimal places preserves the original value — 678.822, as it already has three decimal places. |
| ROUND(678.822, -1) | 680 | Rounds to one place to the left of the decimal (to the tens place). The number is rounded to the nearest ten — 680. |
| ROUND(678.822, -2) | 700 | Rounds to two places to the left of the decimal (to the hundreds place), resulting in 700. |
| ROUND(678.822, -3) | 1000 | Rounds to three places to the left of the decimal (to the thousands place), resulting in 1000. |
Rounding Up
The ROUNDUP function always rounds a value up, regardless of the number after the rounding place. This is useful in situations where a higher value is required, even if the fractional part is less than 5. For example, when calculating material stock or time estimates to avoid shortages.
| Formula | Result | Comment |
|---|---|---|
| ROUNDUP(678.822, 0) | 679 | Rounds up to the nearest whole number (0 decimal places). The result is 679, as rounding always goes up. |
| ROUNDUP(678.822) | 679 | Rounds up to the nearest whole number (default). The result is 679, even if the fractional part is less than 0.5. |
| ROUNDUP(678.822, 1) | 678.9 | Rounds up to one decimal place. The result is 678.9, as rounding always goes up. |
| ROUNDUP(678.822, 2) | 678.83 | Rounds up to two decimal places, resulting in 678.83, even if the last digit is less than 5. |
| ROUNDUP(678.822, 3) | 678.822 | Rounding up to three decimal places preserves the original value — 678.822, as it already has three decimal places. |
| ROUNDUP(678.822, -1) | 680 | Rounds up to the nearest ten, resulting in 680. |
| ROUNDUP(678.822, -2) | 700 | Rounds up to the nearest hundred, resulting in 700. |
| ROUNDUP(678.822, -3) | 1000 | Rounds up to the nearest thousand, resulting in 1000. |
Rounding Down
The ROUNDDOWN function always rounds a number down, regardless of the digits after the rounding place. This is useful in scenarios where exceeding a limit must be avoided, such as budgeting or planning.
| Formula | Result | Comment |
|---|---|---|
| ROUNDDOWN(678.822, 0) | 678 | Rounds down to the nearest whole number. The result is 678, as rounding always goes down regardless of the fractional part. |
| ROUNDDOWN(678.822) | 678 | Rounds down to the nearest whole number (default). The result is 678, even if the fractional part exceeds 0.5. |
| ROUNDDOWN(678.822, 1) | 678.8 | Rounds down to one decimal place. The result is 678.8, as digits after the first decimal place are ignored. |
| ROUNDDOWN(678.822, 2) | 678.82 | Rounds down to two decimal places, resulting in 678.82, as digits beyond the second decimal place are truncated. |
| ROUNDDOWN(678.822, 3) | 678.822 | Rounding down to three decimal places preserves the original value — 678.822, as it already has three decimal places. |
| ROUNDDOWN(678.822, -1) | 670 | Rounds down to the nearest ten, resulting in 670. |
| ROUNDDOWN(678.822, -2) | 600 | Rounds down to the nearest hundred, resulting in 600. |
| ROUNDDOWN(678.822, -3) | 0 | Rounds down to the nearest thousand, resulting in 0, as all significant digits are dropped. |
¡Gracias por tus comentarios!
