Why is Excel rounding when I truncate?

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.
 
P

Peo Sjoblom

How do you truncate using formatting?

=TRUNC(L2*M2*0.00125)


--


Regards,


Peo Sjoblom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top