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.
