Forum Discussion
Round Function
Is there a way to use the MRound function but have it round UP to the nearest $0.25?
The CEILING.MATH function does that:
=CEILING.MATH(A2, 0.25) returns the value of cell A2 rounded up to the nearest multiple of 0.25.
(And FLOOR.MATH rounds down to the nearest multiple of the specified value)