Calculate right side of decimal point only

[Dan]

Hi,

Can anybody tell me how to perform a calculation on two
cells, using only the numbers on the right-hand side of
the decimal place?

Example:

10.334 and 33.245 are in seperate cells. I want to work
out the difference between just 334 and 245.

Is this possible?

Thanks for your help!

 

[Frank Kabel]

Hi
try
=MOD(a1,1)-MOD(B1,1)

 

[Govind]

Hi ,

You can try

=(10.334-int(10.334))-(33.245-int(33.245))

Govind.

 

[Dan]

Thank you, both answers worked perfectly.

Is there a similar way I can using just the numbers
before the decimal point in a calculation?

I did try Google but haven't found anything that helped.

 

[Frank Kabel]

Hi
INT(A1)-INT(A2)

or
TRUNC(A1)-TRUNC(A2)

See the help for differences regarding negative values

 

[Dan]

Fantastic.

Thanks for that. You've really saved me a lot of trawling
though help docs

- Dan