MROUND showing inconsistent results
Hi, I am trying to use MROUND formula to round to the nearest 100.
However, there is some inconsistency that I spotted.
original number * multiplier = number to round
Why are the output number different when the "number to round" is the same?
I want it to round to the nearest 100. If there number is just nice halfway in between, it should round up.
How should I apply the formula to round up for example 1?