Question
Infosys
IN
Last activity: 11 Feb 2021 8:38 EST
Issue while rounding negative number
Facing issue while rounding negative numbers.
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.