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 -----