Rounding and applying remainders.

[JRL]

Hello again!

I want to make an automatic table that looks basically like this....

[TABLE="width: 500"]
<tbody>[TR]
[TD]Beginning total[/TD]
[TD]143.9847[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Full[/TD]
[TD]143[/TD]
[TD]Tenths[/TD]
[TD]9[/TD]
[TD]Hundredths and Below[/TD]
[TD]8.4[/TD]
[/TR]
</tbody>[/TABLE]

Hopefully whatever is entered into the "Begging Total" would automatically be broken into the "Full", "Tenths" and "Hundredths and Bellow" cells respectively.
Nothing in my array should ever have less then a 0.001 value, but if it does it would be nice if it ignored >0.001 as shown in the example, if that is possible.

Thank you in advance.

 

[Joe4]

Assuming your value of 143.9847 is in cell A1, these formulas should return what you need:

Full: =INT(A1)
Tenths: =MID(A1,FIND(".",A1)+1,1)+0
Hundreds and Below: =MID(A1,FIND(".",A1)+2,2)/10

 

[JRL]

That got it! Thank you very much.