Rounding Numbers
 

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?

Rounding Numbers
 

=ROUNDDOWN(A1,2)

--
Kind regards,

Niek Otten

"KHinMN" wrote in message
...
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?

Rounding Numbers
 

"KHinMN" wrote in message
...
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

Rounding Numbers
 

Hi KHinMN

See if this gets you there.

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

HTH
Regards,
Howard

"KHinMN" wrote in message
...
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?