Remainder

Kevin H. Stecyk · May 17, 2005

Hi,

If I have a number like 5.428 and just want the .428, is there an easy way
to do this? It is sort of the opposite of truncate.

Regards,
Kevin

N Harkawat · May 17, 2005

=5.428-int(5.428)

Kevin H. Stecyk · May 17, 2005

"N Harkawat" ...

=5.428-int(5.428)

Thank you.

Gary Brown · May 17, 2005

=MOD(5.428,1)

or if 5.428 is in A1

=MOD(A1,1)

HTH,