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" <nospam@no123spam.com> wrote in message
news:O3uvS%23xWFHA.712@TK2MSFTNGP14.phx.gbl...
> 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
>

[Kevin H. Stecyk]

"N Harkawat" ...
> =5.428-int(5.428)
>

Thank you.

[Gary Brown]

=MOD(5.428,1)

or if 5.428 is in A1

=MOD(A1,1)

HTH,
--
Gary Brown
gary.DeleteThis2SendMeAnEmail.Brown@kinneson.com


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