Let say A1's value is
If I use
=ROUND(A1,2) formula in excel, this will produce
I know this is the right one.
What I want to do is to change
0.34 value to
Microsoft Excel provides three functions for round numbers to the nearest multiple of 0.5:
=MROUND(A1,.05). This lets you round in .05 increments.