ROUNDUP()

Syntax. ROUNDUP(number,num_digits)

Definition. This function rounds a number up to any number of decimal places.

Arguments

  • number (required) The real number to be rounded up

  • num_digits (required) The number of decimal places to which you want to round the number

Background. Unlike ROUND(), the ROUNDUP() function always rounds a number up. The num_digits argument indicates the number of decimal places to round the number. If the value of num_digits is:

  • Greater than zero, the number is rounded up to the specified number of decimal places.

  • Equal to zero, the number is rounded up to the nearest integer.

  • Less than zero, the number is rounded up to the left of the decimal point.

Examples. Assume that you want to wallpaper a room and calculate how many ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial