Thread
:
Remainder
View Single Post
#
4
Gary Brown
Posts: n/a
=MOD(5.428,1)
or if 5.428 is in A1
=MOD(A1,1)
HTH,
--
Gary Brown
"Kevin H. Stecyk" wrote:
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
Reply With Quote