Decimal value help

[Damo10]

Hi,

I am looking for a formula that will give me the decimal value from a number. i.e. if cell A1 contains 10.2 then the formula result in cell B2 will be 0.2

Regards

 

[Rick Rothstein]

Alternatively this should produce the same result:

=VALUE("0."&IFERROR(MID(A1,SEARCH(".",A1,1)+1,1),0))

Here, the number in bold can be toggled to the number of digits you want after the decimal point:

Note: IFERROR is available in Excel 2007 and above.

Here is another alternative that is not dependent on Excel being version 2007 or above (same ability to change decimal size with the bold number as you indicated)...

=ROUNDDOWN(A1,1)-INT(A1)

 

[circledchicken]

Thanks - thats a much cleaner way to do it!

 

[pgc01]

Here is another alternative that is not dependent on Excel being version 2007 or above (same ability to change decimal size with the bold number as you indicated)...

=ROUNDDOWN(A1,1)-INT(A1)

Nice, much simpler!