How to truncate to tenths digits without rounding
 

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

How to truncate to tenths digits without rounding
 

=ROUNDDOWN(A1,1)
--
Gary''s Student - gsnu200737


"Steve Haack" wrote:

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

How to truncate to tenths digits without rounding
 

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

"Steve Haack" wrote:

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