F
f252863
I have a formula:
=L2*M2*0.00125
this gives me the number 252.96
if i truncate to zero decimal places using cell formatting it returns
253??? Also if the value is 252.46 it truncates to 252? How is it
doing this?
I though truncating meant removing the extra decimals not rounding.
=L2*M2*0.00125
this gives me the number 252.96
if i truncate to zero decimal places using cell formatting it returns
253??? Also if the value is 252.46 it truncates to 252? How is it
doing this?
I though truncating meant removing the extra decimals not rounding.