How to truncate to tenths digits without rounding

S

Steve Haack

I need the result of a formula to be calculated and displauyed to the tenths
digit, but I do not want to Round it, I simply want to drop the digits after
the tenths.

If I change the display formatting of the cell, it will use the underlying
number in other calculations, but I only want it to use to the tenths without
it being rounded.

How do I do that?

Thanks,
Steve
 
D

Dave Breitenbach

You can also use the "trunc" function to do that that more explicitly - see
help for that function to try it out.
 

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

Similar Threads

Date and Number cell formats 4
How do I round to the nearest 5? 2
Rounding 3
Converting time to decimal format 17
I need a formula to do some calculations with time. 2
How to make repeating drop-down lists? 2
How to truncate digits? 6
Formula Conversion Problem 19

Top