Extract everything to the right of a decimal as an integer?

[dpucane]

Is there a way have the "decimal" come up with everything to the right of the decimal in "strike" as an integer?
For example, next to "146.5" would be "5", next to "146.33" would be "33", "152.75":"75" and so on. Right now I have
=--RIGHT(DJ11,FIND(".",DJ11)-3)
but I have to change the "3" at the end to "2" whenever there's 2 decimal numbers (.33) as opposed to 1 (.5)

Thanks for any help you can give me.

 

[Jonmo1]

Try

=--RIGHT(A1,LEN(A1)-FIND(".",A1))

Assuming there will always be a decimal value in the cell.
If the value is a whole number, it will return #VALUE! error.

That could be handled with ISERROR or something.

 

[Momentman]

Something like this

Excel 2010
	A	B
1	146.5	5
2	76.75	75
3	134.556	556
Sheet1

Cell Formulas
Range	Formula
B1	=RIGHT(A1,LEN(A1)-FIND(".",A1))

 

[njimack]

=a1-int(a1)