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