Return Decimal Portion Of Number

Re: After The Decimal Point

=Mod(A1,1). This doesn't work for negative numbers, though.

Re: After The Decimal Point

=right(a1,len(a1)-find(".",a1))

Re: After The Decimal Point

For Sicarii's method, I would suggest putting +0 or *1 at the end to convert it to a number; otherwise, Excel reads it as text and formulas won't work.

Re: Return Decimal Portion Of Number

A1-TRUNC(a1)

Quote from anon125;424254

trunc gives just the numbers before the decimal point.
How do i get the numbers after the point.
Original number minus trunc seems messy!

Re: Return Decimal Portion Of Number

One more: =MOD(A1,1)

Re: Return Decimal Portion Of Number

Quote from Armando Montes;604905

One more: =MOD(A1,1)

Sorry Armando but this will not work correctly for negative numbers. The only thing I've found that does work is A1-TRUNC(A1)

It's easy to run a check:

1) Cell C54 contains 10.298
C54-TRUNC(C54) yields 0.298
MOD(C54,1) yields 0.298

2) Cell C54 contains -10.298
C54-TRUNC(C54) yields 0.298
MOD(C54,1) yields 0.702

Re: Return Decimal Portion Of Number

You might add ABS:
=MOD(ABS(C54),1)

Re: Return Decimal Portion Of Number

Quote from Armando Montes;628799

You might add ABS:
=MOD(ABS(C54),1)

Yes, indeed, that works fine! Thank you, Armando.

I'm surprised, actually, that Excel doesn't seem to have a function that returns the mantissa. It has all sorts of similar functions (round, trunc, int, mod) - but not this one.

If anyone knows otherwise, please let me know!