Rounding Numbers

[Guest]

I need to "lop off" a fractional number -- but not round it. Kind of like
truncating only not to an integar -- keeping to 100th decimal place.

1.6595959 would be 1.65

Is that the same as rounding down? I guess I'll try that next -- unless
someone else has another idea?

 

[Niek Otten]

=ROUNDDOWN(A1,2)

 

[Bruno Campanini]

I need to "lop off" a fractional number -- but not round it. Kind of like
truncating only not to an integar -- keeping to 100th decimal place.

1.6595959 would be 1.65

Is that the same as rounding down? I guess I'll try that next -- unless
someone else has another idea?

TRUNC(1.6595959, 2) = 1.65

Ciao
Bruno

 

[L. Howard Kittle]

Hi KHinMN

See if this gets you there.

=LEFT(A1,FIND(".",A1)+2)*1

HTH
Regards,
Howard