Dear friends,
I have a few lists of data where my desire outcome should reflect only the numbers after the decimal places. Example
[TABLE="width: 447"]
<tbody>[TR]
[TD]List 1[/TD]
[TD]Result[/TD]
[TD][/TD]
[TD]List 2[/TD]
[TD]Result[/TD]
[TD][/TD]
[TD]List 3[/TD]
[TD]Result[/TD]
[/TR]
[TR]
[TD]4.001[/TD]
[TD]0.001[/TD]
[TD][/TD]
[TD]4.1[/TD]
[TD]0.1[/TD]
[TD][/TD]
[TD]4.01[/TD]
[TD]0.01[/TD]
[/TR]
[TR]
[TD]4.002[/TD]
[TD]0.002[/TD]
[TD][/TD]
[TD]4.2[/TD]
[TD]0.2[/TD]
[TD][/TD]
[TD]4.02[/TD]
[TD]0.02[/TD]
[/TR]
[TR]
[TD]4.003[/TD]
[TD]0.003[/TD]
[TD][/TD]
[TD]4.3[/TD]
[TD]0.3[/TD]
[TD][/TD]
[TD]4.03[/TD]
[TD]0.03[/TD]
[/TR]
[TR]
[TD]4.004[/TD]
[TD]0.004[/TD]
[TD][/TD]
[TD]4.4[/TD]
[TD]0.4[/TD]
[TD][/TD]
[TD]4.04[/TD]
[TD]0.04[/TD]
[/TR]
[TR]
[TD]4.005[/TD]
[TD]0.005[/TD]
[TD][/TD]
[TD]4.5[/TD]
[TD]0.5[/TD]
[TD][/TD]
[TD]4.05[/TD]
[TD]0.05[/TD]
[/TR]
</tbody><colgroup><col span="2"><col><col span="2"><col><col span="2"></colgroup>[/TABLE]
List 1, 2 or 3 will be keyed in manually by me. Is there any formula to fix the Result based on the above example?
Thank you.
I have a few lists of data where my desire outcome should reflect only the numbers after the decimal places. Example
[TABLE="width: 447"]
<tbody>[TR]
[TD]List 1[/TD]
[TD]Result[/TD]
[TD][/TD]
[TD]List 2[/TD]
[TD]Result[/TD]
[TD][/TD]
[TD]List 3[/TD]
[TD]Result[/TD]
[/TR]
[TR]
[TD]4.001[/TD]
[TD]0.001[/TD]
[TD][/TD]
[TD]4.1[/TD]
[TD]0.1[/TD]
[TD][/TD]
[TD]4.01[/TD]
[TD]0.01[/TD]
[/TR]
[TR]
[TD]4.002[/TD]
[TD]0.002[/TD]
[TD][/TD]
[TD]4.2[/TD]
[TD]0.2[/TD]
[TD][/TD]
[TD]4.02[/TD]
[TD]0.02[/TD]
[/TR]
[TR]
[TD]4.003[/TD]
[TD]0.003[/TD]
[TD][/TD]
[TD]4.3[/TD]
[TD]0.3[/TD]
[TD][/TD]
[TD]4.03[/TD]
[TD]0.03[/TD]
[/TR]
[TR]
[TD]4.004[/TD]
[TD]0.004[/TD]
[TD][/TD]
[TD]4.4[/TD]
[TD]0.4[/TD]
[TD][/TD]
[TD]4.04[/TD]
[TD]0.04[/TD]
[/TR]
[TR]
[TD]4.005[/TD]
[TD]0.005[/TD]
[TD][/TD]
[TD]4.5[/TD]
[TD]0.5[/TD]
[TD][/TD]
[TD]4.05[/TD]
[TD]0.05[/TD]
[/TR]
</tbody><colgroup><col span="2"><col><col span="2"><col><col span="2"></colgroup>[/TABLE]
List 1, 2 or 3 will be keyed in manually by me. Is there any formula to fix the Result based on the above example?
Thank you.