Explanation
MROUND rounds to nearest values based on a supplied multiple.
The difference is that CEILINGalwaysrounds up.
MROUND will round a number up or down, depending on the nearest multiple.
CEILING Function
The Excel CEILING function rounds a given numberupto the nearest specified multiple.
CEILING works like theMROUND function, but CEILINGalways rounds up.
FLOOR Function
The Excel FLOOR function rounds a given number down to the nearest specified multiple.
FLOOR works like the MROUND function, but FLOORalways rounds down.
