Difference between ROUNDUP and CEILING in Microsoft Excel

ROUNDUP rounds a number up to a specified number of decimal places. For example, if you have the number 3.14159 and you want to round it up to two decimal places, you would use the formula =ROUNDUP(3.14159, 2), which would return 3.15. If the number you are rounding is already at or above the halfway point between two possible rounding values, ROUNDUP will always round up to the higher value.

CEILING rounds a number up to the nearest multiple of a specified number. For example, if you have the number 15 and you want to round it up to the nearest multiple of 5, you would use the formula =CEILING(15, 5), which would return 15. If the number you are rounding is already a multiple of the specified number, CEILING will return that number.

1. ROUNDUP rounds a number up to a specified number of decimal places.
2. CEILING rounds a number up to the nearest multiple of a specified number.