big problem
 

After calculation, there are some data contain decimal, how to use function
or other methods to change from case a to case b?

case a:
1.1
1.2
1.6
2.2

case b:
0.1
0.2
0.6
0.2

big problem
 

hi,
not big probem. small problem..... not even problem, really...
=mod(A2,1)

copy(drag) down.
regards
FSt1

"Wu" wrote:

After calculation, there are some data contain decimal, how to use function
or other methods to change from case a to case b?

case a:
1.1
1.2
1.6
2.2

case b:
0.1
0.2
0.6
0.2