How do you use a formula to round up in Excel?

To round up a number to the next highest whole number of a certain multiple use the CEILING function. Use the built in function ROUND for general rounding to the nearest value. It can round down or round up. There is a function called ROUNDUP which always rounds up.

The CEILING function takes two arguments, the first is the number to be rounded up, the second is whole number multiple to round up to. For example: CEILING(1.2345,1) gives 2 but CEILING(1.2345,5) gives 5

To round the contents of cell A1 to the next highest whole 10 and put the result in cell B2 you would: Click on cell B2 Type =CEILING(A1,10) Click on cell A1 Type 14.65 And cell B2 will show the result 20 which is 14.65 rounded to the next highest whole multiple of 10.

CEILING will not handle negatives numbers and will return a #NUM! error if you try.