Remainder

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

=5.428-int(5.428)



"Kevin H. Stecyk" <[email protected]> wrote in message
news:O3uvS%[email protected]...
> 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)
>

Thank you.

=MOD(5.428,1)

or if 5.428 is in A1

=MOD(A1,1)

HTH,
--
Gary Brown
[email protected]


"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
>
>
>