Quick Answer

ROUNDUP Function

ROUNDUP always rounds numbers up, never down, to the specified decimal places.

Syntax

ROUNDUP

(number, num_digits)

Parameters

Parameter	Description	Required
number	The number to round up.	Required
num_digits	The number of decimal places to round to.	Required

Basic Example

Always round up to 2 decimal places

=ROUNDUP(3.14159, 2)

Result3.15

Rounds 3.14159 up to 2 decimal places, resulting in 3.15.

Advanced Examples

Example 1: Round up to nearest whole number

Order quantities

Always round up to the next whole unit

=ROUNDUP(A1, 0)

Result: 13

Rounds 12.1, 12.5, and 12.9 all up to 13.

Example 2: Calculate minimum hours for billing

Time tracking

Round up minutes to the nearest quarter hour for billing

=ROUNDUP(A1/15, 0)*15

Result: 30

Converts 22 minutes to 30 minutes (rounded up to nearest 15).

How ROUNDUP Works

ROUNDUP always rounds numbers away from zero, regardless of the decimal value. 1.01 rounded to 0 decimal places becomes 2.

1

Select output cell

Choose where the result should appear.

2

Enter formula

Type =ROUNDUP(number, decimal_places).

3

Press Enter

The result shows the rounded-up number.

Important Notes & Limitations

ROUNDUP always increases the number (or makes it less negative).
Use ROUNDDOWN for the opposite behavior.

Common Errors & Fixes

#VALUE!Non-numeric arguments

Fix: Ensure both arguments are numbers.

Download Practice File

Practice ROUNDUP with Real Data

Download a sample CSV file with pre-populated data and practice exercises for the ROUNDUP function. Works in both Excel and Google Sheets.

Works in Google SheetsCompatible with ExcelIncludes exercises

File format: CSV (comma-separated values) - opens in Excel, Google Sheets, and all spreadsheet apps

Related Functions

ABS

ABS converts negative numbers to positive, leaving positive numbers unchanged.

ACOS

Returns the angle (in radians) whose cosine is the supplied number.

ASIN

Returns the angle (in radians) whose sine is the supplied number.

ATAN

Returns the angle (in radians) whose tangent is the supplied number.

ATAN2

Returns the angle in radians to a point given by its x and y coordinates.

CEILING.MATH

Rounds up to a multiple of significance, with a mode for negative numbers.

Frequently Asked Questions

What is the difference between ROUND and ROUNDUP?

ROUND follows standard rounding rules (0.5 rounds up), while ROUNDUP always rounds up regardless of the decimal value.