Explanation
TheROUNDUP functionrounds a numberupto a given number of places.
The number of places is controlled by the number of digits provided in the second argument (num_digits).
you’re free to see that ROUNDUP is a rather heavy-handed function, so use with care.
it’s possible for you to use theCEILING functionto round a number up to a given multiple.
If you want to discard the decimal portion of a number, you might use theTRUNC function.
Unlike standard rounding, where only numbers less than 5 are rounded down, ROUNDUP roundsall numbers up….
