ExcelBanter - Remainder

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Remainder (https://www.excelbanter.com/excel-discussion-misc-queries/26549-remainder.html)

Kevin H. Stecyk

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

N Harkawat

=5.428-int(5.428)

"Kevin H. Stecyk" wrote in message
...
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

"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

All times are GMT +1. The time now is 10:16 AM.