If you enter “-1”, it will round down to the nearest ten If you enter “-2”, it will round down to the nearest hundred MROUND Function The MROUND function rounds a number to the nearest multiple that you specify. For example, you can use it to round numbers to the nearest 5, 1...
The ROUND, ROUNDUP, and ROUNDDOWN functions are almost exactly the same. In fact, all three have the same arguments and these arguments are used in the exact same way. The difference is what each function does with the values you give them: regular rounding, rounding up, or rounding down....