How can perform ROUND.HALFUP in Excel?-CodePudding

Excel only provide below Rounding modes.

But how can I round a value to HalfUp And HalfDown!??

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