Opposite Function INT

Copper Contributor

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 That would be =MOD(cellref,1)

@MichSimo1962 , @Riny_van_Eekelen 

MOD() is for positive numbers, e.g. =MOD(-1.25,1) returns 0.75.

I'd use

= A1 - TRUNC(A1)

 

@Sergei Baklan Oh yeah. forgot about that one.

Thanks for your help.