1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Excel ROUNDUP Function

Rounding Numbers in Excel


Excel ROUNDUP Function

Excel ROUNDUP Function

© Ted French

Related Tutorial: Using the ROUNDUP function in calculations

The ROUNDUP function is used to round a number upwards towards the next highest number.

ROUNDUP is similar to the ROUND function except that it always rounds a number upward while the ROUND function will round up or down depending on whether the last digit is greater than or less than 5.

The syntax for the ROUNDUP function is:

= ROUNDUP ( Number, Num_digits )

Number - the value to be rounded.

Num_digits - the number of decimal places to reduce the above number to.

Example: Rounding Up with the ROUNDUP Function:

For help with this example, see the image above.

  1. Enter the following data into cell D1: 34.321

  2. Click on cell E1 in the spreadsheet - this is where the function will be located.

  3. Click on the Formulas tab of the ribbon menu.

  4. Choose Math & Trig from the ribbon to open the function drop down list.

  5. Click on ROUNDUP in the list to bring up the function's dialog box.

  6. In the dialog box, click on the Number line.

  7. Click on cell D1 in the spreadsheet.

  8. In the dialog box, click on the Num_digits line.

  9. Type in a 1 to reduce the number in D1 to 1 decimal place.

  10. Click OK.

  11. The answer 34.3 should appear in cell E1.

  12. When you click on cell E1 the complete function = ROUNDUP ( D1 , 1 ) appears in the formula bar above the worksheet.

Related Tutorials

©2014 About.com. All rights reserved.