Facing issue while rounding negative numbers.
For positive number like 17.5 its rounding 18 correct. But if
For eg: -17.5 should round to -17, but it is rounding to -18.
The property can hold negative as well as positive numbers.
Using rounding method (Round up to nearest option) from presentation tab of cell properties.
Can you please suggest an alternative.
We just want to display the rounded value and not change the value in the clipboard.
Thanks in Advance.
Issue while rounding negative number.
If anyone have other approach plz suggest.
Quick reply is appreciated.
Hi @sadhana, have you tried the "Round towards positive infinity" rounding method?
5 days later
duraisankar
Its like if above 5 then its should consider next number if <5 then consider lower number.
Entered values
Results: I have entered first value is 35335 its rounding to 36k but expected result should be 35k.
E.g if its 35,500 then it should be 36k
The results for negative number is correct but for positive number its always considering next number.
please help I need some approach its urgent requirement.