Updated: November 18, 2026

If you need Google Sheets how to round numbers without breaking your formulas, the fix is simple once you know which rounding function matches the result you want. You can round to whole numbers, decimals, tens, hundreds, or always push numbers up or down with just one formula. The key is choosing the right function, then using it consistently across your sheet.

Use the main rounding functions

Google Sheets gives you a few built-in ways to handle number rounding. The most important are ROUND, ROUNDUP, and ROUNDDOWN. These handle standard rounding, forced rounding up, and forced rounding down.

ROUND for normal rounding

Use ROUND when you want standard rounding to the nearest value. If the digit after your cutoff is 5 or more, Sheets rounds up. If it is 4 or less, Sheets rounds down.

Example: =ROUND(A1, 0) rounds 12.5 to 13 and 12.4 to 12. Use 0 for whole numbers, 1 for one decimal place, and 2 for two decimal places.

ROUNDUP and ROUNDDOWN for forced results

Use ROUNDUP when you want every result moved up away from zero. Use ROUNDDOWN when you want every result moved toward zero. These are the formulas people mean when they search for a Google Sheets round up formula or a Google Sheets how to round down answer.

Examples: =ROUNDUP(A1, 0) turns 12.1 into 13. =ROUNDDOWN(A1, 0) turns 12.9 into 12. For negative numbers, these functions still work based on direction, not just size.

Round to whole numbers, decimals, and specific places

The second argument controls where the rounding happens. This is the part that solves most Google Sheets rounding formula questions.

Round to whole numbers

Use 0 as the second argument to remove decimals completely.

  1. =ROUND(A1, 0) gives standard whole-number rounding.
  2. =ROUNDUP(A1, 0) forces the next whole number up.
  3. =ROUNDDOWN(A1, 0) removes decimals and moves down.

Round to decimal places

Use positive numbers to keep decimals. =ROUND(A1, 2) keeps two decimal places, so 7.126 becomes 7.13. =ROUND(A1, 1) keeps one decimal place, so 7.126 becomes 7.1.

This is the cleanest way to control Google Sheets number rounding without changing the underlying value in the source cell.

Round to tens, hundreds, and larger values

Use negative numbers to round to the left of the decimal point. =ROUND(A1, -1) rounds to the nearest 10. =ROUND(A1, -2) rounds to the nearest 100. This works the same way with ROUNDUP and ROUNDDOWN.

Example: =ROUNDUP(143, -1) becomes 150, and =ROUNDDOWN(143, -1) becomes 140.

How to round up or down with the exact formula you need

If you are searching for Google Sheets round up number, Google Sheets round up function, or how to round up a number in Google Sheets, the formula is direct. Use ROUNDUP with the number of decimal places you want to keep.

Round up a number in Google Sheets

Use =ROUNDUP(number, places). For example:

  • =ROUNDUP(3.141, 2) becomes 3.15
  • =ROUNDUP(3.141, 0) becomes 4
  • =ROUNDUP(3141, -2) becomes 3200

Round down a number in Google Sheets

Use =ROUNDDOWN(number, places). For example:

  • =ROUNDDOWN(3.149, 2) becomes 3.14
  • =ROUNDDOWN(3.149, 0) becomes 3
  • =ROUNDDOWN(3141, -2) becomes 3100

Round off with a simple nearest-value result

If you want Google Sheets round off behavior, use ROUND. That is the standard round off function, and it is the one to use for grades, totals, estimates, and displayed values that need ordinary nearest-number rounding.

Keep numbers from rounding when Sheets changes them automatically

If Google Sheets keeps rounding up, the issue is usually formatting, not the actual value. A cell can display a rounded number while still storing the full number behind the scenes. That is why your formula result and the visible cell can look different.

Stop display rounding

Select the cells, then change the number format so more decimal places are visible. If the sheet is showing whole numbers only, the value may not be rounded at all, just hidden by the format. Increase decimal places from the toolbar until the full value appears.

Turn off rounding up caused by formulas

If a formula includes ROUNDUP, ROUND, or a custom formula that rounds values, remove that function and return to the raw number or a different format. For example, replace =ROUND(A1, 0) with =A1 if you want the exact value displayed, then change cell formatting instead of the formula.

Always round down instead

If you need all results to stay at or below the original value, use ROUNDDOWN. This directly answers searches like Google Sheets always round down and Google Sheets how to round up numbers in the opposite direction. It is the correct choice for budgets, inventory limits, and conservative estimates.

Round cells with formulas, copied ranges, and mixed data

When you need to round many cells in Google Sheets, place the formula in a helper column and fill it down. That keeps your source data unchanged and makes the result easy to reuse in charts, summaries, and exports.

Apply the formula to a range

  1. Put your formula in the first result cell, such as =ROUND(A2, 2).
  2. Press Enter.
  3. Drag the fill handle down the column, or double-click it if the adjacent column is filled.
  4. Copy the rounded results and paste values only if you need static numbers.

Handle text and blanks safely

If a range includes blanks or text, wrap the rounding formula in a check. For example, =IF(ISNUMBER(A2), ROUND(A2, 2), “”) rounds only numeric cells and leaves everything else empty. This is useful for imported data and mixed tables.

Common mistakes with Google Sheets rounding

Most problems come from confusing value rounding with display formatting. Another common mistake is using the wrong place value, such as 1 when you needed 2 decimal places, or -1 when you wanted whole numbers.

Using the wrong function

ROUND does not always round up, and ROUNDUP does not behave like normal nearest rounding. Choose the function based on the rule you want, not the number you see. If you need to round up formula results every time, use ROUNDUP. If you want ordinary rounding, use ROUND.

Forgetting that formatting can hide decimals

If a number looks rounded but your formula is correct, check the cell format before changing the formula. A stored value can still show as 15 when the actual number is 15.32. That is a display issue, not a rounding error.

Frequently Asked Questions

What is the Google Sheets round function?

The Google Sheets round function is ROUND. It rounds to the nearest value based on the digit after the place you choose. Use =ROUND(number, places) for normal nearest-number rounding.

How do I round up in Google Sheets?

Use ROUNDUP. For example, =ROUNDUP(A1, 0) rounds a number up to the next whole number, and =ROUNDUP(A1, 2) rounds up to two decimal places.

How do I round down in Google Sheets?

Use ROUNDDOWN. For example, =ROUNDDOWN(A1, 0) removes decimals and moves the result down, while =ROUNDDOWN(A1, -1) rounds down to the nearest 10.

How do I stop Google Sheets from rounding up my numbers?

Remove any ROUNDUP or rounding formula from the cell, then change the cell format if you only want the display to change. If Sheets is showing fewer decimals than you expect, the value is still there, and the format is hiding it.

How do I round cells in Google Sheets without changing the original data?

Put the rounding formula in a new column, such as =ROUND(A2, 2), and leave the source column untouched. This gives you rounded output while preserving the original numbers for later use.