How to use the ROUNDUP function?

herd of animals on grass field near mountains

  • Applies to: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2019, Excel 2016, Excel 2019 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, Excel for Mac 2011, Excel Starter 2010. 

This post will teach you about what the ROUNDUP function is in Microsoft Excel. It will cover a summary of this function, its formula syntax structure, vital constraints of it usage, and also an example for you to experiment with and see how it works.

Summary of ROUNDUP Function

The ROUNDUP function is a mathematical function that simply rounds a number up, away from 0 (zero).

A man taking part in a rodeo with a horse and a cow - symbolises the ROUNDUP function.
Image by tcdeveloper from Pixabay.

Formula Syntax of ROUNDUP Function

ROUNDUP(number, num_digits)

The ROUNDUP function syntax contains these arguments:

  • Number  –  Required. Whichever actual number that you prefer to be rounded up.
  • Num_digits  –  Required. The amount of digits to which you seek to round number.

A herd of sheep being rounded up.
Image by PublicDomainPictures from Pixabay.

Constraints of its usage

  • ROUNDUP acts similarly to ROUND, however it differs in that it constantly rounds a number up.
  • When num_digits exceeds 0 (zero), then number is rounded up to the stated number of decimal places.
  • Anytime num_digits is 0, then number is rounded up to the closest integer.
  • If num_digits is below 0, then number is rounded up to the left of the decimal point.

Example

Copy the sample data in the table underneath, and paste it into cell A1 of an unused Excel worksheet. For formulas to indicate results, pick them, press F2, and then press Enter. If you must at any point, you can alter the column widths to gain a complete view of the whole dataset in all its wonder!

FormulaDescription (Result)Result
=ROUNDUP(3.2,0)Rounds 3.2 up to zero decimal places.4
=ROUNDUP(76.9,0)Rounds 76.9 up to zero decimal places.77
=ROUNDUP(3.14159, 3)Rounds 3.14159 up to three decimal places.3.142
=ROUNDUP(-3.14159, 1)Rounds -3.14159 up to one decimal place.-3.2
=ROUNDUP(31415.92654, -2)Rounds 31415.92654 up to 2 decimal places to the left of the decimal point.31500

Other Similar Topics

ROUND

MROUND

ROUNDDOWN

EVEN

ODD

Other Links

Back to Software Bytes – Official Website

Back to Excel Tutorial

Expand your Office skills

EXPLORE TRAINING

Got It

Get instant Excel help

CONNECT TO AN EXPERT NOW

Subject to Got It terms and conditions

Leave a Reply

%d bloggers like this: