Excel round 0.34 to 0.35

Question

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

Duke Nukem · Answer 1 · 2019-06-15T08:41:52.867

4

Use =ROUND(A1*2,1)/2 or =MROUND(A1,.05). This lets you round in .05 increments.

edited Jun 15 '19 at 08:41

answered Jun 15 '19 at 08:15

Duke Nukem

harrymc · Accepted Answer · 2019-06-15T11:24:43.567

4

Microsoft Excel provides three functions for round numbers to the nearest multiple of 0.5:

To round a number down to nearest 0.5, use the FLOOR function, for example
=FLOOR(A2, 0.5).
To round a number up to nearest 0.5, use the CEILING function, for example
=CEILING(A2, 0.5).
To round a number up or down to nearest 0.5, use the MROUND function, for example =MROUND(A2, 0.5). Rounding up or down depends on the remainder from dividing the number by multiple - if the remainder is equal to or greater than half the value of multiple, the number is rounded upward, otherwise downward.

edited Jun 15 '19 at 11:24

answered Jun 15 '19 at 08:48

harrymc

interesting. Seems Mround only works for positive values. – Forward Ed Jun 15 '19 at 15:04
1

If negatives involved, try instead =MROUND($A3, SIGN($A3) * 0.5) – BowlOfRed Jun 15 '19 at 16:54

2 Answers2