Remainder

[Kevin H. Stecyk]

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]

=5.428-int(5.428)

 

[Kevin H. Stecyk]

"N Harkawat" ...

=5.428-int(5.428)

Thank you.

 

[Guest]

=MOD(5.428,1)

or if 5.428 is in A1

=MOD(A1,1)

HTH,