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 rolls of wallpaper you need for 463 square feet. A roll is 30 feet long and 3 feet wide. The result is three rolls. The corresponding formula looks like this:

=ROUNDUP(463/30 • 3,0)

First you divide the area you want to wallpaper (463 square feet) by the size of a roll (30 feet x 3 feet). Then you round the result up to an integer because you can only buy entire rolls. You can also include the length of one piece of wallpaper and the estimated waste in the calculation.

More examples for this function are:

• =ROUNDUP(1.9,0) returns 2.

• =ROUNDUP(-2.8,0) returns -2.

• =ROUNDUP(18,-1) returns 20.

See Also

CEILING(), CEILING.PRECISE(), FLOOR(), FLOOR.PRECISE(), INT(), MOD(), MROUND(), ROUND(), ROUNDDOWN(), TRUNC()

Sample Files

Use the ROUNDUP worksheet in the Chapter16.xls or Chapter16.xlsx sample file. The sample files are found in the Chapter16 folder. For more information about the sample files, see the section titled Using the Sample Files.