Thread: Remainder
View Single Post
  #4   Report Post  
Gary Brown
 
Posts: n/a
Default

=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