Thread: big problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Wu Wu is offline
external usenet poster
 
Posts: 36
Default big problem

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