Fresh Excel Tips

For this example, all prices have to be rounded up to whole $100 units. To do this, you use the CEILING function. This function returns a number that is rounded up to the nearest multiple of significance.
CEILING(number, significance)
number: The value to be rounded.
significance: The multiple to which the number will be rounded up.

To round up values to multiples of 100:

1. In cells A2:A10 list some prices.
2. Select cells B2:B10 and type the following formula: =CEILING(A2,100).
3. Press Ctrl+Enter.

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

1. Use the FLOOR function to round down values to the nearest 100
2. Use the MROUND function to round values to the nearest multiple of 10 or 50
3. How to Use the MROUND function to round prices to 5 or 25 cents
4. How to Round Time to the nearest 15 minute in Excel
5. How to Use the ROUND function to round time values to whole minutes