Forum Discussion
Rounding is not showing properly
5 Replies
Isn't this basically the same question as Rounding issue ?
- No ,
Rounding issue ? in this case rounding the number to 2 significant figure .
Then again round to with respect to the resolution.
Here we needed to directly round to 2 significant figure
At that time the above mentioned error is showing.
I Check with both excel and online rounding the answer is different
- Can you share the workbook please (anonymized)?
ajmal_pottekattil_yoousuf You also have to take into account what the cell format is. If you enter the number 0.007 into a cell and leave the format as "General", Excel will display it as 0.007, regardless of how it is rounded. Change the number format to display 4 decimals to get 0.0070 displayed.
Also note that changing the # of displayed decimals may also affect rounding of the value shown in the cell (not of the value used for further calculations!)
