fractions

[Tom]

Hi all,
I looked for a function that will return a fraction from a number.
i.e input=a=190.38
output= b =0.38
I tried =a-int(b) it didnt work in some cases.

Thanks for your help,
Tom

 

[Frank Kabel]

Hi
if this value is in A1 try
=A1-INT(A1)

in whih cases does your formula not work?

 

[Tom]

Hi Frank,
It does not work when the value of A1 is negative.
any ideas?

Thanks,
Tom

 

[Frank Kabel]

Hi
try
=A1-TRUNC(A1)

e.g. for -1.2 this will return -0.2