Forum Discussion
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 advance.
4 Replies
MichSimo1962 , Riny_van_Eekelen
MOD() is for positive numbers, e.g. =MOD(-1.25,1) returns 0.75.
I'd use
= A1 - TRUNC(A1)SergeiBaklan Oh yeah. forgot about that one.
MichSimo1962 That would be =MOD(cellref,1)
- Thanks for your help.
