Explanation
The ExcelCEILING functionrounds a numberupto a given multiple.
The multiple to use for rounding is given as the second argument (significance).
If the number is already an exact multiple, no rounding occurs.
If you want to round down to the nearest half, you’re free to use theFLOOR function.
CEILING works like theMROUND function, but CEILINGalways rounds up.
