Fresh Excel Tips

Similar to the ROUNDDOWN function as explained here, the ROUNDUP function can be used to round up numbers in a worksheet. Here is the syntax that is used:
ROUNDUP(number, num_digits)
number: Any real number to be rounded up.
num_digits: The number of digits number will be rounded up to. If greater than 0, number is rounded to num_digits decimal places. If 0, number is rounded to the nearest integer. If less than 0, number is rounded to the left of the decimal point.

To round up numbers:

1. In cells A2:A10 enter numbers with a decimal point.
2. In cells B2:B10 enter the number of decimal places the number should be rounded up to.
3. Select cells C2:C10 type the following formula: =ROUNDUP($A2,$B2).
4. Press Ctrl+Enter.

This tip is compatible with Excel 97, 2000, 2003 and 2007.

1. How to Use the ROUND function to round numbers in Excel
2. How to Use the ROUNDDOWN function to round numbers down
3. How to Use the FIXED function to round and convert numbers
4. How to use the DOLLAR function to convert number to currency
5. How to Use the MROUND function to round prices to 5 or 25 cents