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