ROUNDUP Google Sheets Formula

Description

Rounds a number to a certain number of decimal places, always rounding up to the next valid increment.

How To Actually Use ROUNDUP() in Sheets

ROUNDUP(value, [places])

Use the ROUNDUP formula to round the numbers in the range A1:A10 up to 2 decimal places. Place your results in the range B1:B10.

Your formula

Hints (2)

Locale Separator ,

Round up in Google Sheets

ROUNDUP always rounds a number up to the next valid increment. Use it when you need ceilings, not standard rounding.

For normal rounding, use ROUND. To round down, use ROUNDDOWN.

2 Better Sheets Tutorials

We're actually gonna go build the dashboard today.

CHAR() COUNTA() HYPERLINK() IF() INDEX() +2 more

Create a simple script to open a particular tab. In this case we're opening to a random motivational quote each time.

Beginner

COUNTA() INDEX() RAND() ROUNDUP()

Transcript-matched member videos for ROUNDUP(). Click through to watch.

Calculate Return on Ad Spend with a formula combination. Bonus: create a...

Intermediate

CONCATENATE() ROUND()

Demystifying the SumIF Formula. Add up your values based on a condition,...

SUMIF() UNIQUE()

Learn more about the ROUNDUP() formula:

Generate a ROUNDUP() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses ROUNDUP(). 2 free AI generations, no signup. Members get unlimited use.

More related tutorials