Apr 29 2021 12:07 AM
Hi anyone. I'm using Windows 10 and Excel 365. I'm looking for the function that give me the numbers, after the komma or digits, when I'm using division. So opposite function INT.
Thank you in advance.
Apr 29 2021 07:08 AM
@MichSimo1962 , @Riny_van_Eekelen
MOD() is for positive numbers, e.g. =MOD(-1.25,1) returns 0.75.
I'd use
= A1 - TRUNC(A1)