2

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

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.

enter image description here

source

  • interesting. Seems Mround only works for positive values. – Forward Ed Jun 15 at 15:04
  • 1
    If negatives involved, try instead =MROUND($A3, SIGN($A3) * 0.5) – BowlOfRed Jun 15 at 16:54
4

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

  • Thanks but didn't work. I'm still getting 0.34 – Sabrina Jun 15 at 8:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.