Forum Discussion
MichSimo1962
Apr 29, 2021Copper Contributor
Opposite Function INT
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 advan...
SergeiBaklan
Apr 29, 2021Diamond Contributor
MichSimo1962 , Riny_van_Eekelen
MOD() is for positive numbers, e.g. =MOD(-1.25,1) returns 0.75.
I'd use
= A1 - TRUNC(A1)
- Riny_van_EekelenApr 29, 2021Platinum Contributor
SergeiBaklan Oh yeah. forgot about that one.