big problem

[Wu]

After calculation, there are some data contain decimal, If I want to obtain
the following results, How to use function to change case 1 to case 2?

case 1:
1.1
1.3
1.4
2.5

case 2:
0.1
0.3
0.4
0.5

 

[Gary Keramidas]

this may do what you want
in b1 enter this formula and drag down

A1-TRUNC(A1)

 

[joeu2004]

After calculation, there are some data contain decimal,
If I want to obtain the following results, How to use
function to change case 1 to case 2?

You need to be more clear. If the value is 1.11, do you still want
0.1, or do you want 0.11?

Also, remember that you what is displayed in the cell might be the
actual value in the cell. What if the actual value is 0.05, but you
see 0.1 because you formatted as Number with 1 decimal place? Do you
want 0.0, or 0.1, or 0.05?

If you want the rounded the tenth of any value, try:

=mod(round(A1*10,0),10)/10


----- original posting -----

 

[Chris Bode via OfficeKB.com]

Well this can be achieved using following simple formula
Let us suppose that you have the data in column A
Then,
Select cell b1 and enter following formula
=A1-FLOOR(A1,1)
Now drag it down to apply the same formula to cells below as well

Have a nice time

Chris