The nearest ten to .96 is 10.
96 rounded to the nearest 10 would be 100.
Any number between 96-99.
96 to the nearest tens place is 100
100
100
10.0
It is 96.
It is 96.
It is already rounded to the nearest thousandths.
there are no decimals to round off in 96.
Try this, substitute B2 and A2 with the cells you are trying to round =(ROUND(B2*96, 0)/96)-(ROUND(A2*96, 0)/96)