Hi all,

As i need to check the decimal places of a number:

1000.456

For example:The first decimal place :4
How can i extract it?

=IF(AND(C10<>0,
C10>J9),C10+J10,CEILING(POWER(SUM(1,(F5/1200)),F3)*(F5/1200)*(C4/(POWER(SUM(1,(F5/1200)),F3)-1)),1))

The statement above results to:
=11514.615

I want to extract the first,second and third decimal place from this formula,then add on some if statements.How can i do it?Thanks a lot