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

Answer 1

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.

Answer 2

Use the function = round(number, num_digits).

Number is the number that you want to round; and num_digits is the number of digits that you want to round to. A positive number rounds to that number AFTER the decimal point, a zero rounds TO the decimal point and a negative number rounds to BEFORE the decimal point.

There are similar functions ROUNDUP and ROUNDDOWN, functions that do what their names suggest.