Home > Enterprise >  How can perform ROUND.HALFUP in Excel?
How can perform ROUND.HALFUP in Excel?

Time:10-30

Excel only provide below Rounding modes. enter image description here

But how can I round a value to HalfUp And HalfDown!?? enter image description here enter image description here


Round Half Up

• Formula used in cell B2

=ROUND(A2,0.5)

• Formula used in cell B3

=TRUNC(A2 SIGN(A2)*0.5)

Round Half Down

• Formula used in cell C2

=TRUNC(ROUNDUP(A2*2,0)/2)

CodePudding user response:

For Rounding Half UP we can set the cell as Number. And also we can change the scaling it is Decimal precision in Number formats.

Right click the cell -> Number formats -> Number. If the decimal places is set to 2, rounding will be as below, When 3rd decimal digit is greater than 4, it will be rounded up. Ex: 2.115 --> 2.12 2.114 --> 2.11

enter image description here

  • Related